Getting contents of a cell when cell reference is in the sheet
 

If I have a cell reference in a cell, how could I get the contents of the
cell instead of the cell reference again.

For example,

A B C D
1
2 5
3 'A2'
4

How could I see the contents of cell A2 using the information in cell C3.
I'm matching one number with another in different worksheets and want to get
a value from the same row as the match. I can get it to return the address of
the data I want to get, but can't get the data.

Incorporate INDIRECT()... i.e. =INDIRECT(A2) will return the contents of A2.

--
Regards,
Dave


"A Nelson" wrote:

If I have a cell reference in a cell, how could I get the contents of the
cell instead of the cell reference again.

For example,

A B C D
1
2 5
3 'A2'
4

How could I see the contents of cell A2 using the information in cell C3.
I'm matching one number with another in different worksheets and want to get
a value from the same row as the match. I can get it to return the address of
the data I want to get, but can't get the data.

Thanks Dave,
For some reason it was just returning the cell reference before.

Andy

"David Billigmeier" wrote:

Incorporate INDIRECT()... i.e. =INDIRECT(A2) will return the contents of A2.

--
Regards,
Dave


"A Nelson" wrote:

If I have a cell reference in a cell, how could I get the contents of the
cell instead of the cell reference again.

For example,

A B C D
1
2 5
3 'A2'
4

How could I see the contents of cell A2 using the information in cell C3.
I'm matching one number with another in different worksheets and want to get
a value from the same row as the match. I can get it to return the address of
the data I want to get, but can't get the data.

Just noticed a typo, my previous post should read "=INIDRECT(C3) will return
the contents of A2.


--
Regards,
Dave


"David Billigmeier" wrote:

Incorporate INDIRECT()... i.e. =INDIRECT(A2) will return the contents of A2.

--
Regards,
Dave


"A Nelson" wrote:

If I have a cell reference in a cell, how could I get the contents of the
cell instead of the cell reference again.

For example,

A B C D
1
2 5
3 'A2'
4

How could I see the contents of cell A2 using the information in cell C3.
I'm matching one number with another in different worksheets and want to get
a value from the same row as the match. I can get it to return the address of
the data I want to get, but can't get the data.