I am struggling with coming up with a formula to solve my problem. I have a set of cells in WS 'WK1' (A5:A8) that I want to look in another WS 'Roster' F2:F25' that match exactly what is in WK1 cell A4 and return the result that is in Roster B2:B25
I created names for the cell range
TPLAY1 = B2:B25 which is the rank of a player located in WS 'Roster' and result I am looking to populate in WK1 A5:A8
TSCHED1 = F2:F25 which is the column in WS Roster that I am searching for matches (there should always be 4 matches
I am using the following formula with no luck
{=IFERROR(INDEX(TPLAY1,SMALL(IF(TSCHED1=$A$4,ROW(TPLAY1)-MIN(ROW(TPLAY1)),ROWS($A$5:A5))),"")}
Thanks in advance for any help
Bookmarks