Select stock code depending on description in next column
 

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

Select stock code depending on description in next column
 

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


"sako 338" wrote:

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

Select stock code depending on description in next column
 

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

"Teethless mama" wrote:

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


"sako 338" wrote:

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

Select stock code depending on description in next column
 

Try to set up a table and use VLOOKUP formula


"sako 338" wrote:

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

"Teethless mama" wrote:

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


"sako 338" wrote:

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

Select stock code depending on description in next column
 

Try to setup the table and use VLOOKUP formula

"sako 338" wrote:

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

"Teethless mama" wrote:

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


"sako 338" wrote:

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