Adding a Value in Excel

Cotta

Hi All,

I have the following formula within Excel, however at present it's returning #N/A as there is no associated value within table two (this can sometimes be the case as the variables fluctuate). Is there a way to correct this issue?

Thanks

=VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A:$I,2,FALSE)+VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A$40:$I$86,2,FALSE)

bod1467

Longwinded way - someone may have a neater approach:

=IF(ISNA(VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A:$I,2,FALSE)+VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A$40:$I$86,2,FALSE)),"",=VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A:$I,2,FALSE)+VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A$40:$I$86,2,FALSE))

Cotta

bod1467 wrote: »

Longwinded way - someone may have a neater approach:

=IF(ISNA(VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A:$I,2,FALSE)+VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A$40:$I$86,2,FALSE)),"",=VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A:$I,2,FALSE)+VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A$40:$I$86,2,FALSE))

Thanks for your response, I've tried your formula but it returns an error within the section highlighted in bold above.

bod1467

Just remove the 2nd = ... that was a cut/paste typo.

rmg1

Or, to be very picky , you could do this:=

=IF(ISNA(VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A:$I,2,FALSE)),0,VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A:$I,2,FALSE))+IF(ISNA(VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A$40:$I$86,2,FALSE)),0,VLOOKUP($A$1,'[combined.xlsx]Money Value'!$A$40:$I$86,2,FALSE))


I think I've got the brackets in the right places, but that will substitute zero for any error values rather than wiping out the entire calculation.

::edit::
Just checked the brackets and added a few inn (hopefully) the right places.

Cotta

Thanks all, I'm up and going again.