| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get multiple data returns from one drop down box?
I have one drop down list with our product names and would like to have 2-3
other types of information on each product returned to other cells in the spreadsheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get multiple data returns from one drop down box?
If you build a table with all the info to return, you could use =vlookup() to
retrieve that other info: =if(a1="","",vlookup(a1,sheet2!a:e,2,false)) to get the assocated value in column B. Tracey wrote: I have one drop down list with our product names and would like to have 2-3 other types of information on each product returned to other cells in the spreadsheet. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loading Data into Multiple sheets in 1 book | Setting up and Configuration of Excel | |||
| Loading Data into Multiple sheets in 1 book | Excel Worksheet Functions | |||
| Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
