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

"Desparate" wrote in message
...
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