I am trying to write a formula to return all of the rows that meet certain criteria from a sheet called "FUND". I am trying to pull the data starting in the third row of that tab. I'm missing something by pulling the data from another sheet. If anyone could tell me what I've done wrong, I wold certainly apprecaite it!
{=IF(ISERROR(INDEX(FUND!A:A,SMALL(IF(FUND!A:A=$A$7,ROW(FUND!A:A)),ROW(1:1))-FUND!1,3)),"",INDEX(FUND!A:A,SMALL(IF(FUND!A:A=$A$7,ROW($A$2:$A$7)),ROW(1:1))-FUND!1,3))}
NOTE: A7 of the current sheet is the lookup in FUND A..
