Index and Match (with multiple results)

[Ajaxs87]

I did an Index and Match function, but I had multiple results and wanted all the results to be listed. Not sure how to alter the formula to do such.

- The list of options is a2:e8 *though I want it to count rows that will be added as new data is entered*.
- The lookup value is L1
-The formula is on K3 and want multiple results to be mentioned below *If there are multiple results*

Thank you in advance for anyone for their time and help.

[Sam Capricci]

maybe try the formula in cell L3 dragged down until it returns blank, then toward the right.
this array (though it may not be an array for your version of excel)...
{=IFERROR(INDEX(A$3:A$9,SMALL(IF($M$1=$F$3:$F$9,ROW(F$3:F$9)-ROW($F$3)+1),ROW(1:1))),"")}

[Ajaxs87]

Thank you for your help and knowledge!