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
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