Using Address References in Another Function

ajt35

New Member
Joined
Jul 13, 2010
Messages
6
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!
 

ajt35

New Member
Joined
Jul 13, 2010
Messages
6
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

Legend
Joined
Jun 19, 2002
Messages
63,651
Try it!

Excel Workbook
BCDEF
123456
211111
31-3111
4-31111
5__________________-1111
611111
711111
80.11071111
911111
101111c1
111111c5
Sheet1
 

Forum statistics

Threads
1,085,863
Messages
5,386,395
Members
401,997
Latest member
cizwiz

Some videos you may like

This Week's Hot Topics

Top