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

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

Guest

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.
 

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

Selecting all cells with content using a variable 3
Changing relative cell reference 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Resolve a text cell reference to the cell's value 3
Use cell contents to build sheet reference 5
Using the contents of a ADDRESS formula as the cell range in a for 3
Excel Import Comments 3

Back
Top