Lookup Formula Help

[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

 

[Rick Rothstein \(MVP - VB\)]

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.

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

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

Rick