Obscure Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used to use a function where a formula would look in a cell to find what
column or row it should use in the formula. Anyone know what this is callled?
Thanks,
KW_Counter
 
Stabbing around somewhat blindly...

INDIRECT() - uses the value in the referenced cell as an address.
ROW() returns the row of the referenced cell
COLUMN() returns the column of the referenced cell
where "referenced cell" is the cell address within the () of those functions.
 
Also, Index() and Offset()

JLatham said:
Stabbing around somewhat blindly...

INDIRECT() - uses the value in the referenced cell as an address.
ROW() returns the row of the referenced cell
COLUMN() returns the column of the referenced cell
where "referenced cell" is the cell address within the () of those functions.
Click to expand...
 
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

Obscure Function 2
Excel VBA 1
Learning arrays. 13
Sum Column above current cell dynamically using function call 7
Excel Help to copy information from one row at a time to another sheet 1
Delete rows based on contents of Col A 0
Header Formating 3
Function or If statement help 1

Back
Top