Hi pros, wondering if anyone can help?
I want to search IDs in tab 1, from tab 2 (the below pic) and return to AccountNumber values. As you can see one ID could have multiple results, some status are "NULL" and some are "1".
I understand that Vlookup will return to the first result it finds, which in my case could be an AccountNumber marked as "NULL".
Basically we need values with "1" when there are multiple identical IDs, if a ID is unique then we can disregard the status, then it will be a normal Vlookup, but when there are multiple results Vlookup may return to a "NULL" AccountNumber which is not we want.
What should I do to make sure it always return to AccountNumber marked as "1" when there are multiple results? Thanks heaps!
I want to search IDs in tab 1, from tab 2 (the below pic) and return to AccountNumber values. As you can see one ID could have multiple results, some status are "NULL" and some are "1".
I understand that Vlookup will return to the first result it finds, which in my case could be an AccountNumber marked as "NULL".
Basically we need values with "1" when there are multiple identical IDs, if a ID is unique then we can disregard the status, then it will be a normal Vlookup, but when there are multiple results Vlookup may return to a "NULL" AccountNumber which is not we want.
What should I do to make sure it always return to AccountNumber marked as "1" when there are multiple results? Thanks heaps!