Forum Discussion

Brass Contributor

Apr 19, 2023

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)))

leolapa

Brass Contributor

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

Share

Resources