May 09 2019 01:00 PM
Hi All,
I am trying to use the Index function to return a list of values that meet one of multiple criteria.
For Example; In the file attached, if I wanted to return all the "Name" values that match the "Numbers" values to the right of the sheet, how would I do that?
Any help would be great!
Thanks,
Will
May 09 2019 01:51 PM
@WillyRusss What would your expected result look like? An Index/Match will return only one value. If you want to return a list, you will need an array formula (unless you have access to Excel's Insider build with the new Dynamic Array functions).
May 09 2019 08:52 PM