Indexing Stops Retrieving Data After Line 50

ksuchow

I have a master project directory that gets linked out to individual project schedules. One of the sheets that links data from the directory is for metadata only. The below formula has worked for the first 50 lines, but is now giving me #INVALID VALUE. I have verified with in the sheet I'm having issues that I can pull in data from the first 50 lines, but it will not retrieve data starting on line 51. Anyone have any ideas?

=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Project Name]$1, {Portfolio Summary Header Row}, 0))

ksuchow

Resolved: The original Reference area only included the 50 lines. I updated the reference area and it works again.

ksuchow

Resolved: The original Reference area only included the 50 lines. I updated the reference area and it works again.

Marcela

Hi @ksuchow!

I´m glad to know you figured it out!