=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.
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.