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!