Hi,
I’m having some issues regarding VlookUp not pulling the correct numbers and could use some help.
On the file attached, there are two tabs, the first tab “Original” contains the nVlookup functions and the numbers that the Vlookup searched within a table. The “Correct” tab contains that table.
For some reason, the Vlookup is pulling the wrong info, and I don’t know why.
Can anyone help?
Thanks?
Leaving the last argument of Vlookup will be considered as approximate match instead of Exact Match
Your Current Formula
=VLOOKUP(A2,Correct!$A$2:$D$4,2)
The above one and this one both are similar which is considered as Approximate match
=VLOOKUP(A2,Correct!$A$2:$D$4,2,1)
=VLOOKUP(A2,Correct!$A$2:$D$4,2,TRUE)
Your actual formula should be
=VLOOKUP(A2,Correct!$A$2:$D$4,2,FALSE)
Or
=VLOOKUP(A2,Correct!$A$2:$D$4,2,0)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
<3 your the best
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks