I am using SUM as a formula to add different vlookup values in different sheets.
The formula works unless vlookup does not find the lookup value in the table array; in which case I get an "#NA" error.
How do I get a vlookup to ignore the value if one of the vlookup values is missing?
=SUM(VLOOKUP(B6,Monday!$1:$1048576,2,FALSE),VLOOKUP(B6,Tuesday!$1:$1048576,2,FALSE), VLOOKUP(B6,Wednesday!$1:$1048576,2,FALSE),VLOOKUP(B6,Thursday!$1:$1048576,2,FALSE),VLOOKUP(B6,Friday!$1:$1048576,2,FALSE))
Thanks in advance.
Bookmarks