Forum Discussion
Replacing a cell values with another across an entire workbook (without using find and replace)
I am using an excel spreadsheet generated from a database, which randomly assigns each client name a unique alpha-numeric identification code. I need to replace the database-generated ID number with ...
If adding a column is an option, try the VLOOKUP function to lookup your companies ID from a given Database ID. All you need to make that work is a translation table like the one in your post above.