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
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