How to get exact match with LOOKUP function?

P

Pete_UK

You can usually use VLOOKUP or HLOOKUP (or even MATCH with INDEX), and
these have an optional 4th parameter (3rd for MATCH) which if set to 0
or FALSE indicate that you want an exact match.

Hope this helps.

Pete
 

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

Auto match destination formatting for Mac 0
Word macro that can call cells out of Excel for a find and replace 0
Match Array returning #NA, Works individually 4
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Match style 0
Descenders clipped 0
How to display the merge function "url" of a picture? 0
Excel 2007 LOOKUP Problem? 3

Top