| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modify Macro Code Depending on Excel Version | Excel Discussion (Misc queries) | |||
| enter item code in one column, automatically get description in ne | Excel Worksheet Functions | |||
| Multiple Sums Depending on a description. | Excel Worksheet Functions | |||
| select based on word CDS being in description field | Excel Worksheet Functions | |||
| How do I set up excel so you enter a stock code and it brings up . | Excel Discussion (Misc queries) | |||
Linear Mode
