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