Thanks Arlu, I was not aware of this feature however, is there a way that by changing the approach here and there still get the work getting done a little faster..

The earlier VBA code was just an example but I would like to know writing the same formulas through VBA do they save on the memory by any chance..

As I have a lot of SUMPRODUCTS, INDIRECT , OFFSET & MULTILOOKUP INDEX ARRAY FUNCTIONS..

Warm Regards
e4excel