LookUp - Exact only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

LookUp - Exact only 2
Lookup returning wrong results 0
vlookup and lookup 12
CONCATENATE & LOOKUP Functions 0
Formula to obtain result from non exact sequence match 2
vlookup - find an alternative approximate match 4
Lookup Function - Specific Values 6
Excel 2007 LOOKUP Problem? 3

Back
Top