Convert ADDRESS() function result to literal text

ajetrumpet

Banned for being rude
Joined
Apr 12, 2008
Messages
569
Office Version
  1. 365
  2. 2016
  3. 2007
Platform
  1. Windows
Guys and Gals,

Can I use the following function result and change it to text?
Code:
=ADDRESS($C$23,2,,,"mysheet")
the result of that function, for me, is this:
Code:
mysheet!$B$10
what I want to do with that literal outcome is plug into the next function, which is this:
Code:
=MATCH($E$8,aboveResult:aboveResult)
So in the cell it looks like:
Code:
=MATCH($E$8,$F$23:$F$24)
but I just get this as a result:
Code:
#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!
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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
 
Upvote 0
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)
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,218,794
Messages
6,144,524
Members
450,550
Latest member
Melanie_Annies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top