Select stock code depending on description in next column

[Guest]

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

 

[Guest]

=IF(H9="A1","3G110",IF(H9="S4","3G117","else......"))

 

[Guest]

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

 

[Guest]

Try to set up a table and use VLOOKUP formula

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

 

[Guest]

Try to setup the table and use VLOOKUP formula

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