If Vlookup is error ( #NA)
Maybe this, but not completely sure.
=IF(ISERROR(VLOOKUP([RU]Sheet1!C3,data!$E$3:$R$16,2,FALSE)),0,((VLOOKUP([RU]Sheet1!C3,data!$E$3:$R$16,2,FALSE))))
HTH
Regards,
Howard
"Steve" wrote in message
...
I have this formula
=IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)0,(VLOO KUP(RU!C3,data!$E$3:$R$16,2,FALSE)),"")
that is producing #NA if it doesn't find C3. I would instead like the
result
to be blank "" when it produces an #NA
Thanks,
Steve
|