Lookup Formula Help

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

I have a formula that returns a blank when a zero is in place
=IF(A15>0,VLOOKUP(A15,'New Labour Standards'!$B$6:$C$990,2,FALSE)," ")

I want this also to return blank when a text entry is in place.

Please could you help.

Thanks

Brian
 
I have a formula that returns a blank when a zero is in place
=IF(A15>0,VLOOKUP(A15,'New Labour Standards'!$B$6:$C$990,2,FALSE)," ")

I want this also to return blank when a text entry is in place.
Click to expand...

I think this will do what you want....

=IF(AND(A15>0,ISNUMBER(A15)),VLOOKUP(A15,$B$6:$C$990,2,FALSE)," ")

Rick
 
Back
Top