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))
