| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a Drop Down Menu
I created a drop menu with the list option from Data Validation. In this case
it is a list of wood product materials. I want to assign a price to each of the selections, and then have that choice appear in another cell on my worksheet. How do I reference the price cells to coincide with the choice made in the drop down menu? I have a separate "tables" sheet to store the data. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
referencing a Drop Down Menu
Check out =VLOOKUP() in Help
"Bailey" wrote: I created a drop menu with the list option from Data Validation. In this case it is a list of wood product materials. I want to assign a price to each of the selections, and then have that choice appear in another cell on my worksheet. How do I reference the price cells to coincide with the choice made in the drop down menu? I have a separate "tables" sheet to store the data. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| referencing drop down menu values in IF-then statements? | Excel Discussion (Misc queries) | |||
| Drop-down menu referencing another drop-down menu? | Excel Programming | |||
| Drop-down menu referencing another drop-down menu? | Excel Programming | |||
| How to create a drop down menu which referencing a different workb | Excel Discussion (Misc queries) | |||
Hybrid Mode
