When using a drop down to get it to reference another cell

[Josh]

How do I select a item in a drop down or Validation and get a price to show
up in another cell. I have 30 items in my drop down. So in column C it will
need to reference 30 prices along with those items. I think you can only
have 7 If then sceriario's. This is excell 2003

 

[Debra Dalgleish]

You can use the VLOOKUP function to return related prices. There are
instructions here:

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

There's a sample order form here were prices are returned for the
selected item:

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

 

[Suleman Peerzade]

Here you have use both validation and v lookup
For eg there in col A there is a item description and in col B there is the
price now you need to validate first col A and the table for the price of
those product should be ready some where on the same sheet far from the main
table.
col A(description) col B (price)
Table 10

Formula for vlook up will be
=VLOOKUP(A2,Q2:R6,2,FALSE)

now any one selecting from the drop down list will get the price accordingly