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.

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.

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.

Create a new sheet with the mfg in column A and the code in column B.

With the mfg name in A2, you could use this formula in an adjacent cell:
=vlookup(a2,sheet2!a:b,2,false)



Stcyrk wrote:

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.

--

Dave Peterson