Hi
I have a large spreadsheet but one that runs very efficiently. That was until I introduced a column of formulas that include the OFFSET function. Now the spreadsheet need over half a minute to recalculate itself every time i change a single value. I know it is the OFFSET function that is causing this as it is volatile. Does anybody have a replacement formula for the one below that achieves the same outcome without using OFFSET?
=OFFSET($WP$5,MATCH(E5&F5&G5,INDEX($WL$5:$WL$1000&$WM$5:$WM$1000&$WN$5:WN$1000,0),0)-1,0,1,1)
Any help would be greatly appreciated.
Doug
Bookmarks