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

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