NA Error

[Guest]

If the referenced cell is empty, I'l get a dread NA Error. Is there a way to get rid of this error message

=IF(Q23<VLOOKUP(A23,$S$10:$T$12,2,FALSE),FALSE,TRUE

Any assistance will be highly appreciated

Thanks,....

 

[Andy B]

Hi

Try this:
=IF(ISNA(VLOOKUP(A23,$S$10:$T$12,2,FALSE)),"",IF(Q23<VLOOKUP(A23,$S$10:$T$12
,2,FALSE),FALSE,TRUE))


--
Andy.

If the referenced cell is empty, I'l get a dread NA Error. Is there a way

to get rid of this error message?