Can anyone help please.
I have the following formula in excel 2013 but need to convert it so it works in excel 2003.
{=IFERROR(INDEX(Holidays!B:B,SMALL(IF((INDEX(Holidays!E:G,0,MATCH(A$1,Holidays!E$1:G$1,FALSE))="h")+(INDEX(Holidays!E:G,0,MATCH(A$1,Holidays!E$1:G$1,FALSE))="hh"),ROW(Holidays!B:B)),ROWS(A$36:A36))),"")}
Thanks in advance
I have the following formula in excel 2013 but need to convert it so it works in excel 2003.
{=IFERROR(INDEX(Holidays!B:B,SMALL(IF((INDEX(Holidays!E:G,0,MATCH(A$1,Holidays!E$1:G$1,FALSE))="h")+(INDEX(Holidays!E:G,0,MATCH(A$1,Holidays!E$1:G$1,FALSE))="hh"),ROW(Holidays!B:B)),ROWS(A$36:A36))),"")}
Thanks in advance