Just wanted to follow up and post the answer here. After playing around with the formula for a while, this is what I came up with!
Formula:
=IFERROR(INDEX(Employees!S:U,SMALL(IF(Employees!S:S=$F$16,ROW(Employees!S:S)),ROW(1:1))-1,3),"")
Just wanted to follow up and post the answer here. After playing around with the formula for a while, this is what I came up with!
Formula:
=IFERROR(INDEX(Employees!S:U,SMALL(IF(Employees!S:S=$F$16,ROW(Employees!S:S)),ROW(1:1))-1,3),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks