I have a database of location names an their corresponding location codes. Over time, people using the database have used slightly different spellings of the location names, which leads to inaccurate totals for each location because each spelling becomes a new entry. The location codes have never changed.

Can I use some from of an IF and VLOOKUP function to return the proper location name (text) in one cell after entering the associated location code (number) in a different cell?

Here’s an example of the location names and their codes:

Fish Ladder1519Ballard Marine1520NW Adhesives1521James Ranch1522

​I have a database of location names an their corresponding location codes. Over time, people using the database have used slightly different spellings of the location names, which leads to inaccurate totals for each location because each spelling becomes a new entry. The location codes have never changed. Can I use some from of an IF and VLOOKUP function to return the proper location name (text) in one cell after entering the associated location code (number) in a different cell? Here’s an example of the location names and their codes:Fish Ladder1519Ballard Marine1520NW Adhesives1521James Ranch1522   Read More

​