So instead of vlookup, use a macro to compare the mfr of an item to the
unique mfr list, if they are equal, place the 4 char code in an adjacent cell
of that row?

"Don Guillett" wrote:

It is assumed that you have a criteria for the code assignment. You could
use a macro to search the list until the criteria is found and put the
appropriate code in an adjacent cell.

Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stcyrk" wrote in message
...
Is it possible to use vlookup, or anything else, to assign a designated 4
char code for a manufacturer. That is, I have a list of all unique mfrs,
I
have assigned a 4 char code to each. Now I want to go back to my item
master
list and assign the 4 char code where the mfr of each item obviously
equals
the mfr in my unique list. Any suggestions would be greatly appreciated.