G Guest Apr 18, 2005 #1 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.
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 Apr 18, 2005 #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
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 Apr 18, 2005 #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
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 Apr 18, 2005 #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 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.
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.
