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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to obtain result from non exact sequence match 2
Formula have a VLOOKUP but want it to =0 if no value is found 3
vlookup and lookup 12
vlookup - find an alternative approximate match 4
LookUp - Exact only 2
Excel 2007 LOOKUP Problem? 3
How to get exact match with LOOKUP function? 1
Slideshow with black border around it 1

Top