Multiple Vlookup Formula

Hi Folks

I am currently trying to populate a cell by adding 2 lookups together from 2 different spreadsheets
It woks when when both spreadsheets has a value but give s #n/A if either one does not have a value.

The formula i am using is

=(VLOOKUP($C6,'Sheet2'!$F$6:$S$98,D$4,0)+(VLOOKUP($C6,'Ser & Mgmt C'!$C$7:$O$103,D$4,0)))

So when both the cells from the different sheet have a value it works but when either one does not have a value it fails.

Any help on this will be highly appreciated.

Thanks

Maybe

=IFERROR(VLOOKUP($C6,Sheet2!$F$6:$S$98,D$4,0),0)+IFERROR(VLOOKUP($C6,'Ser & Mgmt C'!$C$7:$O$103,D$4,0),0)

Hi

Did you try to use IFERROR, infront of your formula?

Yes tried is error but if i use is error i get a 0
I want the formula to bring back the value it is present in either of the 2 sheets.

Hope what i am saying makes sense

Yes it makes sense, but in my test, what I posted worked for me.

What do you get for each of the Vlookup's if you seperate them?

Hi Thanks for your reply

For the 1st lookup i get a #n/a as there is no value and for the 2nd one i get a value

and when i add both the look up together i get #n/a as the 1st lookup does not bring back any value

If you are getting an #N/A for the first...

This would return a zero
=IFERROR(VLOOKUP($C6,Sheet2!$F$6:$S$98,D$4,0),0)

And for the second, you said it returns a value
IFERROR(VLOOKUP($C6,'Ser & Mgmt C'!$C$7:$O$103,D$4,0),0)

When we put them together you should get

0+2 = 2

Can you run the evaluate formula?

Place your curson on the cell with the formula >> Formulas tab >> Evaluate formula >> step through the formula to see what is happening.

Thanks Seems to have done the trick

Many thanks for your help.

You're very welcome...glad you got it all sorted out and thanks for the feedback