Help needed to do a lookup and replace

[wei82]

I have Sheet1 for location column and location shortform column and Sheet 2 for location column only. Anyway i can replace the location in sheet2 with the shortform location if it matches sheet1 location. AS attached file

[Pete_UK]

It is not a good idea to use Merged Cells.

You can put this formula in B1 of Sheet2:

=IFERROR(VLOOKUP(A1,Sheet1!A:B,2,0),A1)

then copy it down. It will give you the abbreviation if the name is recognised, otherwise it will give the original name. However, you will also see zero on (most) alternate rows, because of your merged cells.

You can fix the values in column B, then delete column A, and then sort that column if you want to remove the zeros.

Hope this helps.

Pete