How to make drop down list relate to other cells or validate more than 1 column.

[a.c.campbell]

Hi, I have a excel spread sheet in excel 2007. I made a list of material in a drop down list by validating the list of material. I want to be able to select an item in the drop down menu and it list the item and then in the next cell beside it show the price the relates to the item selected and then beside that show the labor for installation. Excel will not let me validate more than 1 column of info to put into a drop down. So how can I select the item, then in the next cell it either automatically put the price and labor number or have a drop down menu that only give you the option to select the price for the item and labor. Thanks for your help!

 

[littleiitin]

You can use Vlookup or lookup formula for last two...Based on drop down selection........

 

[a.c.campbell]

thanks