Formula /drop down list

[leamingtongirl]

Hi,


Can you some help me with the following: What I am tring to achieve is drop down list that return a value if the correct item is selected from list, for example

column A Cell 3 would have list of all types of doors, Column C cell 3 would return the correct value for a door that would be selected from the drop-down list.


Column A Column C

Dropdown list Value


Door 838 35.00

Door 762 49.00

Door 686 30.00


Any ideas?


thank inadvance

 

[fred]

click your cell on A3.

go to "Data", "Data Validation", "Data Validation...", Settngs, then

on the "Allow:" click on the pull down menu where you see the phrase "Any Value". Click on it and pick "List"


Under source of the same window you need to hi-light the cells carrying your product list. Hit enter key and you have created a list.


on column C. all you have to do is a vlookup function.


hope this help.