Good day! It's been quite a while since I last logged on. I have need of your [this forum's] expertise again.
Here it is: Sheet A has 20 different entries for 5 different people. I need Sheet B to pull these individual entries so it's all under one table, in one person's name.
Normally, a simple vlookup or match/index will suffice. But how do I do that if there are multiple entries? Vlookup will only pull multiple instances of the same entry.
I appreciate the help! TIA!
Here it is: Sheet A has 20 different entries for 5 different people. I need Sheet B to pull these individual entries so it's all under one table, in one person's name.
Normally, a simple vlookup or match/index will suffice. But how do I do that if there are multiple entries? Vlookup will only pull multiple instances of the same entry.
I appreciate the help! TIA!