Hi-
I have two columns of data and I would like the formula displayed below to return all names in my first column that have the same values in the second column matching cell E1. My array ranges from from rows A1 to B199. However, the formula only calculates to A118. Even if I change the formula to go through A199.
=IFERROR(INDEX($A$1:$A$118, SMALL(IF($B$1:$B$118=E$1, ROW($A$1:$A$118), ""), ROWS($A$1:$A1))), "")
Bookmarks