#N/A error

[fdjudjo]

Hello,
I'm trying to vlookup names in 5 different tabs and add the values together. The problem comes when looking up for a name that doesn't exist in one of the tabs and returns the whole thing as #N/A. What I want it to do is look at the NA as a 0 and sum the rest of the numbers.
Can anyone help me with this?
Thanks

 

[Norie]

Try this.

=IF(ISNA(VLOOKUP()), 0, VLOOKUP())

Replace VLOOKUP() with your current formula.

 

[Aladin Akyurek]

Hello,
I'm trying to vlookup names in 5 different tabs and add the values together. The problem comes when looking up for a name that doesn't exist in one of the tabs and returns the whole thing as #N/A. What I want it to do is look at the NA as a 0 and sum the rest of the numbers.
Can anyone help me with this?
Thanks

You seem to need a conditional sum across multiple sheets. If so, see:

http://www.mrexcel.com/board2/viewtopic.php?t=123314