Formula for drop down list that return a value

[Chicks Rule]

Hi,

Can you some help me with the following: What I am try 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.

Any ideals?

 

[VoG]

If you create a table of door types and values you could use a VLOOKUP formula http://www.contextures.com/xlFunctions02.html