Will vlookup work for this scenario

[mregan]

I apologize ahead of time, my office manager and I are excel novices. We have been plugging away on a new workbook for our salesmen to try to automate most of the quoting processes. I have a workbook that we use to calculate labor and material quotations. On this sheet, in the blue boxes, we add quantites of each material package we need per job. On a separate sheet we have labor hours assigned to each material package. So a quantity of 1-1 Head Package may be 10 hrs labor, a quantity of 1-2 head package 16 hrs labor, etc. Can I create a formula that could see how many quantites of each material package we added to this form and it would add up the labor assigned to each material package and put the total in the Standard install labor box?
My office manager was thinking we could use a vlookup formula but we're not sure if that is the correct formula. She seems pretty confident if we were only selecting 1 of the material packages she could get the vlookup to see the labor assigned to that material package and populate the Standard install labor box. We're not so sure we can do the same and have it add up multiple labor amounts.

 

[awoohaw]

as long as there are no duplicates in the column you are looking (I assume column A - or the first column above) then you can return the same row from another column. But, you must then never insert intervening columns without adjusting the formula (the column number you select in argument 3).
VLOOKUP(B2,$A$3:$E300,3,FALSE)
Instead, if the XLOOKUP function is available then
(assume the lookup value is in Cell B2. and you want the dollars from the 3rd column (assuming column C) and assuming 300 rows in your data.

XLOOKUP(B2,$A$3:$A$300, $C$3:$C$300)

if your excel does not work with xlookup then use this INDEX MATCH function:
INDEX($C$3:$C$300,Match(B2,$A$3:$A$300:$A$300))

 

[mregan]

Thank you. I'll have her give this a shot.

 

[awoohaw]

You're welcome, and welcome to the Forum.
Happy to help!