# Looking for a solution on how to convert a returned cell address to a cell reference

1. ## Looking for a solution on how to convert a returned cell address to a cell reference

I have a formula (AL15) to determine the address of the last column with a value greater than 1. =COUNTIF(C16:AC16,">=1")+2. I then use this column value to aquire the Absolute row "15" and the determined column=(ADDRESS(15,AL15,4)). This returns to me a Column value and row value that I need to use as a refference. How can I convert this returned value to a reference. Thank you for any help

2. ## Re: Looking for a solution on how to convert a returned cell address to a cell refere

See the INDIRECT() function in Excel help

eg. =Indirect(B5) will look at reference within B5 and go to that cell for value to extract.

3. ## Re: Looking for a solution on how to convert a returned cell address to a cell refere

FWIW I doubt you need the string reference... you will find INDEX probably does what you want using row/column numbers.

=INDEX(\$15:\$15,AL15)

is the same as

only it's not volatile (a good thing).

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1