INDEX multiple matches and criteria, growing lists

Below is a snapshot of a table "People" containing names, eye colors and ages. Then to the right of it, under a light blue background, there is a list with a couple of names and eye colors combin...

INDEX Multi Matches, Criteria.xlsx14 KB

excel

Formulas and Functions

Lorenzo
Apr 19, 2023
leolapa
Seems to do what you want with the sample you shared:
=FILTER(People[Age],ISNUMBER(XMATCH(People[Name]&People[Eye],E2:E3&F2:F3)))

Lorenzo

Silver Contributor

Apr 19, 2023

leolapa

Seems to do what you want with the sample you shared:

=FILTER(People[Age],ISNUMBER(XMATCH(People[Name]&People[Eye],E2:E3&F2:F3)))

leolapa

Brass Contributor

Apr 19, 2023

Easy peasy... Thank you sir!

Lorenzo
Silver Contributor
Apr 19, 2023
Glad you have an option & Thanks for providing feedback

Forum Discussion

INDEX multiple matches and criteria, growing lists

Resources