Good Morning,
I am trying to return multiple results based off 1 criteria. I have the following furmula:
=IFERROR(INDEX(Employees!$C$2:$D$10,SMALL(IF(Employees!$C$2:$C$10='Global Assumptions'!$Q$3,ROW(Employees!$C$2:$C$10)-MIN(ROW(Employees!$C:$C))+1),ROWS($A$1:$A1)),2),"")
The value in...