Referencing

[mario]

I have a formula on worksheet "1" that uses the "large 1,2,3" function to return the 3 highest growth rates from 20 separate worksheets. If large function returns growth rate from sheet 15, how do I tell excel to reference the result of the "large" function and return information located in cell A3 from sheet 15 (or whatever sheet results from the "large" function)? Thanks.

 

[Visions_Fugitive]

Mario,

Try this formula, assuming that the cell that has the sheet name is A2:

=INDIRECT(A2 & "!$A$3")