I have in c/A A3:A109 data that contains station names
I also have in c/B B114:B233 a list of station names, some match c/A's list and some don't
I am trying to create a formula in c/A A114:A233 that will match
1] c/A A3:A109 to c/B B114:B233 and
2] replace with c/B when match is found
I have tried and came up with this it is wrong can anyone help me with this formula:
=MATCH(A3,B114:B233,0)*INDEX(A3,0,1)
Thx
Sean
I also have in c/B B114:B233 a list of station names, some match c/A's list and some don't
I am trying to create a formula in c/A A114:A233 that will match
1] c/A A3:A109 to c/B B114:B233 and
2] replace with c/B when match is found
I have tried and came up with this it is wrong can anyone help me with this formula:
=MATCH(A3,B114:B233,0)*INDEX(A3,0,1)
Thx
Sean