broncos347
Active Member
- Joined
- Feb 16, 2005
- Messages
- 293
- Office Version
- 365
- Platform
- Windows
I have a VLOOKUP formula =VLOOKUP(D7,'Combined COWD'!$A$1:$I$414,7,FALSE) which obviously returns #NA when the answer is false.
Is there a way to have it return a ZERO rather than the #NA?
Is there a way to have it return a ZERO rather than the #NA?