I created the following array in Excel 2007 and it works great.

=IF(ISERROR(INDEX('Roll Cleaning Data'!C:D,SMALL(IF(cleaning_status="
",ROW(cleaning_status)),ROW('Roll Cleaning Data'!1:1)),2))," ",INDEX('Roll
Cleaning Data'!C:D,SMALL(IF(cleaning_status="
",ROW(cleaning_status)),ROW('Roll Cleaning Data'!1:1)),2))

I then save the file in a 2003 compatable version and when I open the file
the data is correct. However, when I make any changes to the Array in the
Excel 2003 and update the array (ctrl + shift + enter) the cells go blank.

I'm thinking either the formula or some part of it is incompatiable with
2003? Any help appreciated.

Greg