S
Steve
I have this formula
=IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(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
=IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(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