multiple find and replace

[jmkerzic]

I have 2 tabs on the spreadsheet. I want to update column N (Location), with a new location which is on the 2nd tab.

I would use Column E as as the lookup value, and add the new location to column N. If the number is not found I want the the Location to stay as it is. Tab 2 is the updated location list.

Lookup e2 on tab1, and if it is on Tab 2 (column B) return with the value that is in Column c on Tab 1 column N. If that value is not found on Tab2, than do not update column N.

Example: If E2 is found on tab 2 it would return 011 (column C) to column N on tab 1. If not found it would change column N.
TAB 1

TAB 2

 

[jmkerzic]

Perfect. Thanks again for the help on this.

 

[mumps]

My pleasure.