I need help on how to create a formula that will assign a name to a specific number. I will be uploading bar code data to excel and each barcode is assigned a specific number, I then need this number to be replaced with a Name. For example Number 1000 - should be assigned to John Smith. The first column will have the number, the second column will have the data and I would like the third column to have the correlating name. Can anyone help me with this?
Bookmarks