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?