This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have two very large files. My reference document with all of my date information is 54,000 rows and the document I'm trying to match to and pull the dates into is 25,000 rows and goes out to column CH.
I'm trying to run an Index Match to fill in dates for the entire matching sheet but it's very slow. I started running the formula and after an hour I was at 7%. Is there a faster way I can index information that the formula I am using below?
=IFNA(INDEX('[workbook]sheet!$A$1:$J$54632,MATCH(1,('[workbook]Sheet'!$A$2:$A$54632=$A2)*('[workbook]sheet'!$E$2:$E$54632=B$1),0),10),"")
I am matching a unique ID in Column A and the Column header to my reference document.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
With that much data, the processing will become slow. If you can share both workbooks and your requirement, we can try to use the Power Query to see if the performance improves.