Select stock code depending on description in next column

S

sako 338

I want to have a stock code (one of four) placed in a cell depending on the
text in the column to the right, the text in this column could be one of
about 200 different entries.
Example: when h9 shows text "A1", I want e9 (i have a few merged cells) to
show 3G110 or if h9 shows "S4", I want e9 to show 3G117

Any suggestions
 
S

sako 338

i wish it was that easy, i have 200 items identified as a1, a2 etc (not in
any particlar order) and depending on what the id is the stock code is
different
 
T

Teethless mama

Try to set up a table and use VLOOKUP formula


sako 338 said:
i wish it was that easy, i have 200 items identified as a1, a2 etc (not in
any particlar order) and depending on what the id is the stock code is
different
Click to expand...
 
T

Teethless mama

Try to setup the table and use VLOOKUP formula

sako 338 said:
i wish it was that easy, i have 200 items identified as a1, a2 etc (not in
any particlar order) and depending on what the id is the stock code is
different
Click to expand...
 
Top