Formula Stops working after Column AM

I have a workbook that takes a master list of documents uploaded and then sorts them by searching for the associated project code and returns the document name and type using the INDEX, SMALL, IF, and ROW functions (method outlined here). Works great until I get to row AM, when the formula stops working and returns only #NUM!. I continue to get this error for all subsequent columns, but is OK on the previous ones.

I can't figure out why the formula stops working after column AM, any ideas?

=INDEX('File Upload Details'!$C$6:$C$612, SMALL(IF('Active Awards Documents'!$AM$2='File Upload Details'!$B$6:$B$612, ROW('File Upload Details'!$B$6:$B$612)-ROW('File Upload Details'!$B$6)+1), ROW(1:1)))

Your ranges are only covering up to Row 612

But the first occurance of the value in AM2 exists in Row #629 of the Details sheet.
629-6+1 = 624

There is no 624th item in the indexed range of $C$6:$C$612

Extend all the ranges to cover the entire dataset in the Details sheet.

Your formula is going up to row 612 while first data is in row 629.
Extend range.

Formula:

Please Login or Register  to view this content.

That did it, thanks both!

You're welcome.