help needed to convert a 2013 formula to a 2003 formula

shina67

Board Regular
Joined
Sep 18, 2014
Messages
67
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
 

Some videos you may like

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
Joined
May 24, 2005
Messages
3,848
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,995
Messages
5,526,130
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top