• 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


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



New Member
Hi guys,

I have attached a file with an example. I try to use Vlookup in order to verify in these people have the right number. The problem is for most of them I have more than one record. If on first is the salary, the second is a bonus, on third is anything else. But when I look for the salary I want just the one record, the True or the false. Can I somehow filter the ID numbers but one row per person?

Thank you,