Very complex formula required - Please help

[aimeem13]

=IF(ISERROR(INDEX('Portfolio Filtered for OS Funds'!$A$2:$C$6628,SMALL(IF('Portfolio Filtered for OS Funds'!$A$2:$A$5801=J$1,ROW('Portfolio Filtered for OS Funds'!$A$2:$A$5801)),ROW(3:3))-1,3)),"",INDEX('Portfolio Filtered for OS Funds'!$A$2:$C$6628,SMALL(IF('Portfolio Filtered for OS Funds'!$A$2:$A$5801=J$1,ROW('Portfolio Filtered for OS Funds'!$A$2:$A$5801)),ROW(3:3))-1,3))

Im using the above formula, with the array brackets.

However, I would like the formual to pick up the value in the "(INDEX('Portfolio Filtered for OS Funds'!$A$2:$C$6628" section, if this value is returns a yes, in the column of another sheet, so it equals yes in column D of sheet 'another list'

Please help, thanks.

 

[aimeem13]

sorry, to be clearer: If the value in the index bit equals Dog and dog equals yes in another sheet, dog will appear, if not leave blank, as in nothing will appear.

 

[aimeem13]

Basically, i am looking to combine these formulas into one coloumn:

=IF(ISERROR(INDEX('Portfolio 31.01.14'!A2:C6173,SMALL(IF('Portfolio 31.01.14'!A2:A6173=J$1,ROW('Portfolio 31.01.14'!A2:A6173)),ROW(1:1))-1,3)),"",INDEX('Portfolio 31.01.14'!A2:C6173,SMALL(IF('Portfolio 31.01.14'!A2:A6173=J$1,ROW('Portfolio 31.01.14'!A2:A6173)),ROW(1:1))-1,3))

=IF(ISNA(VLOOKUP(J2,'Offshore List - Open'!A:D,4,0)),"",J2)