LookUp - Exact only

D

Desparate

I have a lookup function that works OK - but it returns the nearest when
there is no exact match. How can I make it only return exact matches and
leave a blank if there is no exact match.

Thanks in advance
 
J

JulieD

Hi

probably by using the match function instead ... if you'ld like to post your
formula we'll be happy to offer suggestions.

Cheers
Julied
 
Top