Referencing

mario · Apr 16th, 2002, 03:39 PM

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 · Apr 16th, 2002, 03:53 PM

Mario,

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 03:39 PM	#1
mario New Member Join Date: Apr 2002 Posts: 5	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.

Apr 16th, 2002, 03:53 PM	#2
Visions_Fugitive New Member Join Date: Apr 2002 Location: Milwaukee, WI Posts: 18	Mario, Try this formula, assuming that the cell that has the sheet name is A2: =INDIRECT(A2 & "!$A$3")