Index/Match hell...

cheap_ash

Board Regular
Joined
Apr 20, 2005
Messages
81
I need to index and match approximately 10,000 rows of data across 7 sheets into one, sorted by date.

This needs to be done dynamically, the data will not be inputted into the massive log but rather one of the 7 other sheets.

Does anyone know of a less laggy way of doing this?
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,372
If you download and install the free add-in Morefunc.xll, you can use the THREED function with INDEX/MATCH. For an example, have a look here...

Hope this helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,647
Members
410,627
Latest member
georgealice
Top