josephekdahl
New Member
- Joined
- Mar 30, 2006
- Messages
- 15
Hi,
I have the following VLOOKUP: =SUM(VLOOKUP(C5,'Closed-Won Opps'!A:H,{4,5},FALSE)). I need it to return "0" where data is missing instead of #N/A.
I'm not dead set on having an array, but tried it by adding lookups (VLOOKUP + VLOOKUP) and adding ISERROR or ISNA and am not having any luck.
Any help on the correct syntax for this would be greatly appreciated.
Thanks,
Joe
I have the following VLOOKUP: =SUM(VLOOKUP(C5,'Closed-Won Opps'!A:H,{4,5},FALSE)). I need it to return "0" where data is missing instead of #N/A.
I'm not dead set on having an array, but tried it by adding lookups (VLOOKUP + VLOOKUP) and adding ISERROR or ISNA and am not having any luck.
Any help on the correct syntax for this would be greatly appreciated.
Thanks,
Joe