Vlookup - Variable look_up value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
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?
 
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)
 
Back
Top