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,
Mariya
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,
Mariya