Excel 2003 - Indirect addressing

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
C

Craig Brandt

I'm simply brain dead this morning and could use a little help.

I have assembled a column of pointers into a table. These pointers are
simply the row number of the selected data in a table. Assuming that this
column starts in A01, I would like to create a formula in B01 that simply
makes B01 equal to the data located in a specified column (use column F for
the example) in the row specified by A01.

I remember doing this before, but it just excapes me this morning.

Thanks in advance for your consideration and help,

Craig
 
=indirect("F"&a1)



Craig said:
I'm simply brain dead this morning and could use a little help.

I have assembled a column of pointers into a table. These pointers are
simply the row number of the selected data in a table. Assuming that this
column starts in A01, I would like to create a formula in B01 that simply
makes B01 equal to the data located in a specified column (use column F for
the example) in the row specified by A01.

I remember doing this before, but it just excapes me this morning.

Thanks in advance for your consideration and help,

Craig
Click to expand...
 
Thanks Harlan.

I have already incorporated the indirect method, but when I saw your
responce, this was the method I had previously used and I had forgotten.

Craig
 
Back
Top