{=iferror(INDEX('Usable Data'!$B$2:$M$201,SMALL(IF('Usable Data'!$M$2:$M$201='Working Staff'!$D$1,ROW('Usable Data'!$M$2:$M$201)-1),ROW(A1)),3),"")}
Also posted this question to Mr. Excel before I knew the rule.
http://www.mrexcel.com/forum/excel-q...no-result.html
Bookmarks