If Vlookup is error ( #NA)
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Steve" wrote in message
...
Worked great. Thank you.
And I do have version 2003.
Steve
"T. Valko" wrote:
What version of Excel are you using?
Try this...
=IF(COUNTIF(data!$E$3:$E$16,RU!C3),IF(VLOOKUP(RU!C 3,data!$E$3:$R$16,2,0)0,VLOOKUP(RU!C3,data!$E$3:$ R$16,2,0),""),"")
--
Biff
Microsoft Excel MVP
"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
.
|