Forum Discussion
Index and Match Function With "Or" Statement
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 m...
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).