How to get an exact mactch with Vlookup

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

Guest

Hi,

I'm using a Vlookup but get a result even if the value I'm looking up is not
the same as the one the table.

I want to get an error if I don't find and exact match. Am I doing something
wrong?

Thanks In advance
Gordon
 
Hi
Make sure you are including the last argument of the function as FALSE,
otherwise an approximate match will do!
 
Hi Gordon

the VLOOKUP function has four parameters, the fourth, if omitted, will allow
the VLOOKUP function do an approximate match ... if you want an exact match
you need to put FALSE or 0 in the fourth parameter.
 
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

Vlookup & exact match 4
Using VLookup when text isn't an exact match 3
VLOOKUP PROBLEM 2
Vlookup, sumproduct, if, sumif... erggg! 1
VLOOKUP Question 6
Match and Vlookup issue 2
Vlookup when lookup criteria is not an exact match 2
Help With VLOOKUP 2

Back
Top