Replace a term in one column with value in next column

R

reagr

New member
Joined
May 1, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
=COUNTIF(A1:A347, "Alabama") Alaska
=COUNTIF(A1:A347, "Alabama") Arizona
=COUNTIF(A1:A347, "Alabama") Arkansas
=COUNTIF(A1:A347, "Alabama") California

How can I replace the "Alabama"s in the first column with "Alaska", "Arizona", "Arkansas" and "California" such that it becomes

=COUNTIF(A1:A347, "Alaska") Alaska
=COUNTIF(A1:A347, "Arizona") Arizona
=COUNTIF(A1:A347, "Arkansas") Arkansas
=COUNTIF(A1:A347, "California") California

I have tried posting this in other places without luck: https://www.excelforum.com/excel-fo...irst-column-with-values-in-second-column.html, https://www.quora.com/unanswered/In...-in-the-corresponding-cell-in-the-next-column
 

Attachments

  • del 68.xlsx
    10.6 KB · Views: 7
Just change the B11 in the formula John gave you to B12
 
As I told John, that doesn't work because I need to put quotation marks around "B11", and when I do it looks up literally "B11" instead of what's in the cell B11.
 
Last edited:
What makes you think you need to use quotes?
Have you actually tried the formula?
 
You must log in or register to reply here.
Back
Top