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

A

auto door lady

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.
 
M

michael.stringfellow

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
 
M

michael.stringfellow

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
 
D

Debra Dalgleish

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 here:

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.
 
Top