I have this formula
{=INDEX(Table2[A],MATCH($B$1&$C$1,Table2[B]&Table2[C],0))}
It works as I expected, giving me the correct value from Table2[A]. With this example there is only 1 correct match.
With my next Table, there are 10 correct matches. I want to display all 10 matches in a Table. I keep trying to add in the ROWS function to this formula, but it messes it up.
Any help would be appreciated.
Bookmarks