indirect reference to a column or row

[Snale]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel This has to be an old question, and probably everyone in the world knows the answer except for me....

I want to make and indirect reference to a row or column in a formula. Such as:
 A(function that gives some row number)

I simply cannot figure how to do this- can I do this? If so, how?

Thanks,
Snale
Dale Brown

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

This has to be an old question, and probably everyone in the world knows the
answer except for me.... <br><br>I want to make and indirect reference to a
row or column in a formula. Such as: <br>
&nbsp;A(function that gives some row number) <br><br>I simply cannot figure
how to do this- can I do this? If so, how? <br><br>Thanks, <br>

I'm not sure I understand completely, but perhaps

=INDEX(A:A, <function>)

or

=INDIRECT("A" & function)

 

[Snale]

Thanks for the reply. I appreciate the help. I'm sorry, I was not very clear. Her is what I want to do:

Scan through a column of dates and find a certain date, call it D. I can do that with

MATCH(D, ,1)
which returns the row that contained the found date. Now I want to use that returned row number to find a cell in that row (C), such as

MATCH(C, A(found row):G(found row),1) which would give the column

Your suggestion of &quot;A&quot; &amp; (found row) did not work - it makes a string, not a cell location.

Does this make sense? Can I do this? I would think that this sort of function would be common, but I don't know how to do it.

Thanks again.

 

[Bob Greenblatt]

Thanks for the reply. I appreciate the help. I'm sorry, I was not very
clear. Her is what I want to do:

Scan through a column of dates and find a certain date, call it D. I can do
that with

MATCH(D, ,1)
which returns the row that contained the found date. Now I want to use that
returned row number to find a cell in that row (C), such as

MATCH(C, A(found row):G(found row),1) which would give the column

Your suggestion of "A" & (found row) did not work - it makes a string, not a
cell location.

Does this make sense? Can I do this? I would think that this sort of
function would be common, but I don't know how to do it.

Thanks again.

Yes, you can do this. Try: match(C,indirect(³A²&foundrow &²g²&foundrow),1)