#N/A error

fdjudjo

New Member
Joined
Dec 1, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,056
Office Version
  1. 365
Platform
  1. Windows
Try this.

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

Replace VLOOKUP() with your current formula.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
fdjudjo said:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,327
Messages
5,571,560
Members
412,405
Latest member
DutchMonkey
Top