To show 0 instead #Value!
VLOOKUP might be returning #VALUE
ISNA only checks for #N/A error... Use ISERROR if you want to suppress
#VALUE errors too...
"user" wrote:
Hello
I am trying to do a vlookup using if(isNa... and if isn't not found, I want
it to show a zero instead of #VAlue!. Not sure why #Value is showing up, as
opposed to the #N/A.
--
Thanks
|