I have the following formula that I'd like to expand on:
Currently it matches value in S1, I'd like to also match value in S2.![]()
=IFERROR(INDEX($A$2:$A$10,SMALL(IF($C$2:$C$10=$S$1,ROW($A$2:$A$10)),ROW(1:1))-1,1),"")
I have the following formula that I'd like to expand on:
Currently it matches value in S1, I'd like to also match value in S2.![]()
=IFERROR(INDEX($A$2:$A$10,SMALL(IF($C$2:$C$10=$S$1,ROW($A$2:$A$10)),ROW(1:1))-1,1),"")
Last edited by Grizraz; 01-06-2020 at 04:25 AM. Reason: correction
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks