Adding up values returned from 5 look ups

[Simon Jones]

Hello,

I am trying to do some stock checks using different worksheets using VLOOKUP.

I am using the code - =VLOOKUP($A2,'pack 1'!$B$2:$D$20,3,FALSE) but sometimes my value in A2 is not found in the worksheet "pack 1" so my look up returns the #N/A value.

Is there something I can put in to return a zero or blank instead of #N/A if the look-up value is not found?

I need to add together the 5 values returned to get a total stock amount so my SUM is not working due to the #N/A value.

Any advice would be greatly appreciated.

thanks in advance!
Simon

[AlKey]

Duplicate post

[AlKey]

Try like this

=IFERROR(VLOOKUP($A2,'pack 1'!$B$2:$D$20,3,FALSE),0)

[Simon Jones]

thanks a lot, that has worked for me