IF Then for multiple selections?

[brudenell]

I have several products in a list in cell C3, let's call them product A,B,C,D. When I select product A, I want D3 to show it's price and E3 to show wattage and F3 to show hours of life.
Price, wattage and hours of life need to be associated to the specific product selected. How do I do this? Thank you for your help.

 

[VoG]

You can create a lookup table then use VLOOKUP http://www.contextures.com/xlFunctions02.html