| 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 |
| 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) | |||
Threaded Mode
