As Worksheets Grow in Size and Slow Down from Memory Consumption, I wonder if Some Formulas should be Avoided. It seems to Me that Vlookup and HLookup functions are Memory Hogs, especially on large blocks of Data. The Indirect Function using the Address Function, is an alternative that seams to calculate faster. Offset and Index functions also seam quicker. Does anyone here know if these observations are true? Is there a Difference?
I have always liked the Vlookup and Hlookup Functions. They are the easiest to construct. I have heard some concern about the sequence of data needing to be inverted because these functions require ascending values. This can be overcome by using the Negative value of the First Column or Row. For example, In Ca they use Game Numbers as Well as Dates. There is no need to invert the Data, all you have to do is multiply all of the Game Numbers by -1 and you Get the Ascending Values required by the Function. Vlookup Functions can also include Indirect, Offset, And Index Functions to establish the Elements of the Function. How does this affect Memory Use?
Can anyone help or direct me to a reference to this Question?
I have always liked the Vlookup and Hlookup Functions. They are the easiest to construct. I have heard some concern about the sequence of data needing to be inverted because these functions require ascending values. This can be overcome by using the Negative value of the First Column or Row. For example, In Ca they use Game Numbers as Well as Dates. There is no need to invert the Data, all you have to do is multiply all of the Game Numbers by -1 and you Get the Ascending Values required by the Function. Vlookup Functions can also include Indirect, Offset, And Index Functions to establish the Elements of the Function. How does this affect Memory Use?
Can anyone help or direct me to a reference to this Question?