Vlookup formula needs to return more than first value

[dixiboy]

Hello,
I have a basic Vlookup formula that I am using to add certain job costs. The formula is as follows:
=IFERROR(VLOOKUP(B235,'1530 - WIP MATERIALS '!A:H,5,FALSE),0)

The formula is looking for a specific job number and returning the associated costs, however it is only returning the first record of that cost and none of the others in the worksheet.
can anyone help with either changing the formula to return multiple values or to sum the values that all pertain to the same job.
Thank you

 

[Joe4]

That is correct. VLOOKUP will only return the first match it finds.

If you are looking for a SUM based on a condition or conditions, take a look at using SUMIF and SUMIFS instead.
https://www.techonthenet.com/excel/formulas/sumif.php
https://www.techonthenet.com/excel/formulas/sumifs.php

 

[Marcelo Branco]

To sum the values try SUMIF.

=SUMIF('1530 - WIP MATERIALS'!A:A,B235,'1530 - WIP MATERIALS'!E:E)

Assumes all the values are in column E of '1530 - WIP MATERIALS'

M.

 

[dixiboy]

That is correct. VLOOKUP will only return the first match it finds.

If you are looking for a SUM based on a condition or conditions, take a look at using SUMIF and SUMIFS instead.
https://www.techonthenet.com/excel/formulas/sumif.php
https://www.techonthenet.com/excel/formulas/sumifs.php

Thanks Joe, much appreciated.

 

[Joe4]

You are welcome.
Glad we could help.

 

[dixiboy]

Thanks Marcelo, I went with the sumif and it works great.