How can I detect when VLOOKUP(_,_,_,FALSE) returns #N/A because there is
not an exact match? If I can detect it I can initiate an alternate
calculation.

I've tried =IF(VLOOKUP(_,_,_,FALSE)="#N/A", True, False) but no cigar.

Any help appreciated.

drb