Hey!
I have a question concerning index / match of a dynamic range.
I have a spreadsheet with three worksheets with many (+50.000) rows which is causing a lot of problems in excel...
I cannot see a solution to change the number of rows in those three sheets (a pivot was a possibility, but thats slow as well...)
I use index / match on 10 other sheets (13 columns each) on about 5000 rows looking up values from the first three sheets...
So as you might see my spreadsheet is big, in file size about 30 mb.

I have tried several ways to cut the file size down and limit the calculations necessary.
So first of all, what is best: using match/index on a dynamic range by using OFFSET($A$1,0,0,COUNT($A:$A),1) or another formula referring to the last row of the sheet...? Here I believe it is a problem that the formula is volatile... a solution could be to use a vba macro to do index/match on a single row at the time and then copy/paste values into the sheet in order not to have all these formulas in the sheet...?

Best regards,