Convert ADDRESS() function result to literal text

[ajetrumpet]

Guys and Gals,

Can I use the following function result and change it to text?

=ADDRESS($C$23,2,,,"mysheet")

the result of that function, for me, is this:

mysheet!$B$10

what I want to do with that literal outcome is plug into the next function, which is this:

=MATCH($E$8,aboveResult:aboveResult)

So in the cell it looks like:

=MATCH($E$8,$F$23:$F$24)

but I just get this as a result:

#N/A

Is there a way to fix that problem? A text conversion function? I've looked through the help files but can't find what I need. thanks!

 

[bryonwoods30]

did you try just using your first formula ADDRESS($C$23,2,,,"mysheet") and putting it straight into your last formula instead of getting the result and then referencing it

 

[Asator]

it sounds like you want to be able to feed a row number to your function and have it pass that to your match statement's lookup range?

if so:
=match(lookup_value,indirect("lookupsheet!"&address($C$23,2)&":"&address($C$23+some offset,2)),0)

 

[ajetrumpet]

did you try just using your first formula ADDRESS($C$23,2,,,"mysheet") and putting it straight into your last formula instead of getting the result and then referencing it

yes I did, no luck.

I will try Indirect() and get back to you guys. thanks!