Apply the best formula from all group sheets

[PRADEEPB270]

I have a file comprising 49 sheets and mentioned the sheet name as my Model name.Sheet no.1 is my summary sheet where I want to apply the formula by grouping all the 48 sheets in a one attempt.
At present,I am applying the VLOOKUP formula 48 times,that is lengthy exercise.Is it any formula to solve the problem?

For your ref.,I have attached a file with 4 model sheets and 1 summary sheet.Pl.refer the attached file .

Regards

Pradeep Kumar Gupta

[DonkeyOte]

formula wise - conducting them separately is better than the alternatives for single cell calculation

Another option would be to use INDIRECT within the VLOOKUP such that you have one formula for all cells in the matrix (speed up entry etc...)
However, at that point those formulae (and the dependants thereof) become Volatile - so whether you want/should to do this or not is for you to decide based on performance impact.

Please Login or Register  to view this content.

It's not always the case that elegance & efficiency go hand in hand in XL I'm afraid.

[DonkeyOte]

Further to the above - in your sample file the cells being referenced are located in identical cells in which case you just use 3D sum references to aggregate.

[PRADEEPB270]

Thank you sir for your nice and best formula.

Regards


Pradeep Kumar Gupta