Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a drop down list with prices in aswell
Hello,
I am trying to create a excel sheet that you enter a drop down list and the price comes up automatically when you enter it ie Apple in one box and price £1.79 in another box I have been trying to figure it out all afternoon i will need a few drop down to create a invoice type of thing for equipement |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create a drop down list with prices in aswell
VLOOKUP formulas will pull the data to appropriate cells.
See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. BTW.........they are called "cells" not "boxes" Gord Dibben MS Excel MVP On Thu, 6 Sep 2007 08:48:01 -0700, Donna wrote: Hello, I am trying to create a excel sheet that you enter a drop down list and the price comes up automatically when you enter it ie Apple in one box and price £1.79 in another box I have been trying to figure it out all afternoon i will need a few drop down to create a invoice type of thing for equipement |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
create a drop down list | Excel Worksheet Functions | |||
Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
How do I tie prices to a drop down list of products in excel? | Excel Discussion (Misc queries) | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions |