idex function

  • Thread starter Thread starter Apriel
  • Start date Start date
A

Apriel

I am trying to using the reference option of the index
function, but it keeps returning the contents rather than
the reference.
 
Use it with cell to get the address

=CELL("address",INDEX(MyRange,1,2))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index Function Problem 7
IF function says too many nested 1
how do I create a cell reference from ADDRESS function return? 3
Idexed problem 2
Table of Contents and Index 5
Using INDEX function to return array row. 1
treat cell contents as reference not value? 3
use of ADDRESS function within CELL function 4

Back
Top