# Reverse INDEX MATCH

Y

#### Yunus

Gents, where am I going wrong...
The formula below only works upto Row 72 of Sheet1.
i.e it only works for Table array \$K\$5:\$BT\$72 not for '!\$K\$5:\$BT\$73 or
beyond.

Sheet 1 Contains the Table with an array of Dates

In Sheet 2 Cell B1=Today()
In Sheet 2 Cell B2= COUNTIF('Sheet1'!K5:BT138, "<"&TODAY())

In Sheet 2 Cell A5 copied down Column A is
=IF(ROWS(\$A\$5:A5)>\$B\$2,"",INDEX('Sheet1'!\$B\$5:\$B\$138,INT(SMALL(IF
('Sheet1'!\$K\$5:\$BT\$138<\$B\$1,(ROW('Sheet1'!\$K\$5:\$BT\$138)-ROW('Sheet1'!\$K
\$5)+1)*10^5+COLUMN('Sheet1'!\$K\$5:\$BT\$138)-COLUMN('Sheet1'!\$K\$5)-1),ROWS
(\$A\$5:A5))/10^5)))

In Sheet 2 Cell B5 copied down Column B is
=IF(ROWS(\$A\$5:A5)>\$B\$2,"",INDEX('Sheet1'!\$K\$3:\$BT\$3,MOD(SMALL(IF
('Sheet1'!\$K\$5:\$BT\$138<\$B\$1,(ROW('Sheet1'!\$K\$5:\$BT\$138)-ROW('Sheet1'!\$K
\$5)+1)*10^5+COLUMN('Sheet1'!\$K\$5:\$BT\$138)-COLUMN('Sheet1'!\$K\$5)+1),ROWS
(\$A\$5:A5)),10^5)))

Why does it only work for data only upto Row 72 . How can I determine
what the cause is.