I have a situation where I'm using VLOOKUP to find a name in a sheet, and then give me a number next to the name.
Unfortunately, I run into situations where the VLOOKUP can't find the name (because it's not in the list) and it gives me "#N/A" instead.
I can understand the reason for this, but unfortunately I'm using SUM to calculate a total of these numbers, and the SUM is always "#N/A" until I manually delete all the cells that contain "#N/A" in the list.
Is there a way I can make the cell equal "0" if the VLOOKUP fails?
Thanks in advance!
Bookmarks