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

A

A Nelson

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.
 
D

David Billigmeier

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

A Nelson

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

Andy
 
D

David Billigmeier

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