Format pull downs

[hamp]

I have a pull down based on Items of equipment (validation) . On sheet EQ LABOR, in col A a list of the diff types of equip. In col B beside each item a pull down with the various sizes for each piece of equip.

On sheet LIST in col A the sizes for each piece of equip which is in the corresponding pull down on sht EQ LABOR.

I can't find a formula that will , based on the pull down selection insert in the corresponding equip item cost for installation EQ LABOR sheet col C and connection labor EQ LABOR col D.

I tried the following =IF(D7=LIST!A2,G7=LIST!C2)=IF(D7=LIST!A3,G7=LIST!C3)=IF(D7=LIST!A4,G7=LIST!C4)=IF(D7=LIST!A5,G7=LIST!C5)=IF(D7=+LIST!A7,G7=LIST!C7)=IF(D7=LIST!A8,G7=LIST!C8)=IF(D7=LIST!A9,G7=LIST!C9)=IF(D7=LIST!A10,G7=LIST!C10)=IF(D7=LIST!A11,G7=LIST!C11)

The cell #'s listed in my text question above don't necessarly match my formula as the question is what I am attempting to accomplish where as the formula is actually my ref cell and col #'s.

Any help would be much appreciated.

 

[Brian from Maui]

Have a look at the VLOOKUP function.

 

[hamp]

My problem at this time is; the pull down works fine and based on selection fills a cell with example 80to100 tons.

My problem is that I can't seem to get excel to respond to the cell with 80to100tons from the pull down with any formula that will transfer the applicable cost to two additional cells from the LIST SHEET to the EQ LABOR sheet.