Using Address References in Another Function

[ajt35]

I am trying to use the references from an address function in another function. Specifically, I would like to use cells F10 and F11 that show the text $C$1 and $C$5 respectively, in the function min($C$1:$C$2). Anyone know how I can do that? Thanks!

 

[mikerickson]

The INDIRECT function should help.

 

[VoG]

Maybe

min(indirect(F10&":"&f11))

 

[ajt35]

VoG,

Thanks for your quick reply. I don't think that will work because the indirect formula returns the value in F10 not the text. I am looking to use the text in the cell itself. Any other ideas?

 

[VoG]

Try it!

Excel Workbook
	B	C	D	E	F
1	2	3	4	5	6
2	1	1	1	1	1
3	1	-3	1	1	1
4	-3	1	1	1	1
5	__________________	-1	1	1	1
6	1	1	1	1	1
7	1	1	1	1	1
8	0.1107	1	1	1	1
9	1	1	1	1	1
10	1	1	1	1	c1
11	1	1	1	1	c5
Sheet1

 

[ajt35]

You are right! My mistake! Thanks again!