Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item numbers result in item description in next field in Excel
I am putting a spreadsheet together and I want the item number to
automatically populate the item description in the next field. Can anyone give me an answer about what syntax I should be using? For example: In cell B5 I would enter item #123 (I have item #'s in a drop down) - I would like cell C5 to automatically display the description of 3" Pipe. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item numbers result in item description in next field in Excel
You need VLOOKUP, see http://www.contextures.com/xlFunctions02.html
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cheryl MM" <Cheryl wrote in message ... I am putting a spreadsheet together and I want the item number to automatically populate the item description in the next field. Can anyone give me an answer about what syntax I should be using? For example: In cell B5 I would enter item #123 (I have item #'s in a drop down) - I would like cell C5 to automatically display the description of 3" Pipe. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide an item subtotal in the row field? | Excel Discussion (Misc queries) | |||
enter item code in one column, automatically get description in ne | Excel Worksheet Functions | |||
Pivot field dropping one item | Excel Discussion (Misc queries) | |||
Calculated Field/Item in a Pivot | Excel Worksheet Functions | |||
How do I use a" item description" in excel to consolidate totals? | Excel Discussion (Misc queries) |