drop down lists

[rockon]

i am trying to make an invoice list. i would like it when i type in a product
or get it from a drop down list for the price of that particular item to show
in the collumn next to it.

 

[Debra Dalgleish]

You can use the VLookup function to return the price. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html

 

[BenjieLop]

You should probably have this set up:

Column X will contain the product name AND
Column Y will contain the product's corresponding price

Assuming that the product name will be entered in Cell A1, enter th
following formula in Cell B1:

=vlookup(A1,$X$1:$Y$100,2,0)

NOTE: Another assumption in the formula is that you only have 10
products hence 100 prices, as well. You can adjust the range in you
VLOOKUP formula as required in your application.