MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need Vlookup Help.


Posted by Sdimaggio on December 10, 2001 1:22 PM

What is happening here? I have a spread sheet that looks like this.

Row A B C
1 1 a 6
2 2 b
3 3 c
4 4 d
5 5 e

I am doing a Vlookup(C1,$A$1:$B$5,2) and the answer is “e” it should be #N/A. When I type in a 4.5 in C1 instead of 6, the answer is “d” it should be #N/A. I need to have the Vlookup function do exact matches. How do I do this?

Background: I have database “A” which has 1800 approval numbers and which is 1800 lines long. I have database “B” which has 25,000 lines and each line has one of the 1800 approval numbers. In database “B” some of the approval numbers are calculated to be active and some are inactive. I am trying to matchup only the active approval numbers back to database “A”. I did a unique advanced filter to eliminate all the duplicate approval numbers. but i'm having problems on the lookup. Is there an easier way?


Posted by Mark W. on December 10, 2001 1:27 PM

You need to supply the 4th (optional) argument of 0 or FALSE (nt)

Posted by Horacio on December 10, 2001 2:13 PM

If you don't put the 4th argument, it will find the closest match... try this(C1,$A$1:$B$5,2,false)

Posted by sdimaggio on December 10, 2001 5:44 PM

Thanks :)