Forum Discussion
VLOOKUP with Identical Lookup Values and multiple columns
I just figured out VLOOKUP and was able to get the information to pull up for the first instance of a lookup value, but I need multiple instances to pull up. I tried doing some research and found a w...
There's a few ways to do it.
My methods
1. INDEX array
2. FILTER (Works if you have 365 fully updated).
Sample attached.