help needed to convert a 2013 formula to a 2003 formula

shina67

Board Regular
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))),"")}

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

pbornemeier

Well-known Member
I believe it will be:
=IF(ISERROR(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:A37)))),"",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:A37))))

This page explains what I did (or at least tried to do):
Excel IFERROR Function

Replies
8
Views
73
Replies
1
Views
27
Replies
3
Views
92
Replies
5
Views
69
Replies
5
Views
43