Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |