The link in your question is good, but it needs to be adjusted as follows. =IFERROR(INDIRECT("B"&SMALL(IF(X25=$D$17:$D$22;ROW($D$17:$D$22);"");ROW($D$17:$D$22)-16));"") Enter as an array formula `{}` by pressing <kbd>Ctrl</kbd>+<kbd>Shift</kbd>+<kbd>Enter</kbd>. The result is 4, 5, and 6 as you requested. Adjustments: - `INDIRECT("B"&` — In your case, you want the value from column B, not the index. - `X25=` instead of `"a"=` because you want the value from that row. - `ROW($D$17:$D$22)-16` instead of `ROW()-2` because the row number is from the D column, not from the location where you're putting the formula.