| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select from list and get value from another list
What formula can I use to fill in cell I7 with a value from a list (in column
L) using another list (in column K). The scenario: I have a list of prices (column L) associated with a list of descriptions (column k) and want to be able to pick a description in a drop-down menu in cell I7 and have the associated price pop up in that same cell. Is this even possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
| Select from a List | Excel Worksheet Functions | |||
| DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
| how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Hybrid Mode
