• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VlookUp not Working?

Andyaf

New Member
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!
 

Attachments

  • Forums Help.xlsx
    11.8 KB · Views: 4
or you may have to leave the fourth argument but need to read this...


If the first column of the database (the column that contains the unique identifiers) is sorted alphabetically/numerically in ascending order, then it’s possible to enter a value of true into this argument, or leave it blank.

If the first column of the database is not sorted, or it’s sorted in descending order, then you must enter a value of false into this argument.

 
Back
Top