How to use AND statement within an IF statement in a complex nested array (Excel)
The following formula works:
{=IFERROR(INDEX(Data!$A:$C, SMALL(IF(Data!$A:$A = Template!$C$2, ROW(Data!$C:$C)), ROW(2:2)), 3, 1), “”)}
The following formula works:
{=IFERROR(INDEX(Data!$A:$C, SMALL(IF(Data!$A:$A = Template!$C$2, ROW(Data!$C:$C)), ROW(2:2)), 3, 1), “”)}