I have a dropdown in a cell, how can I get corresponding data for.
 

I have created a dropdown list for items in a cell, I need the corresponding
price for the item selected to appear in another cell.

The VLOOKUP function will do it. You'll need to have a list items and
their price. Use HELP for function details. Reply if you need more
assistance.

Mike

The VLOOKUP function will do it. You'll need to have a list items and
their price. Use HELP for function details. Reply if you need more
assistance.

Mike

You can use a VLookup formula to return the matching data when a
selection is made from the data validation dropdown.

There are instructions for VLookup in Excel's help, and he

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

There's a sample file here that uses data validation and a VLookup
formula to fill in an order form:

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

Under 'Data Validation' look for "Order Form". It might give you some
ideas for your workbook.


auto door lady wrote:
I have created a dropdown list for items in a cell, I need the corresponding
price for the item selected to appear in another cell.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html