Rudy4histo
Reputation: 13
How do I return the contents of a cell that I have the address for (e.g. "A2")?
I have cell addresses in one worksheet formatted as text strings (e.g. "A1", "B22", "F332") and I'd like to return the contents of those particular cell addresses from another worksheet. How do I do this?
Upvotes: 1
Views: 23
Answers (1)
Gary's Student
Reputation: 96753
Use INDIRECT():
=INDIRECT("Sheet3!" & A1)
This gets the contents of cell A1 from Sheet3.
If your sheetname includes blanks, encapsulate it in single quotes.
Upvotes: 1
Related Questions
- Use ADDRESS (or similar) to return full column address
- Excel-How can I get the address of a cell instead of a value?
- In Excel how can I return the address of a cell based on the value in a sheet without previously limiting to a certain column or row?
- Return cell value with an address
- Use Cell Address to Get Cell's Value
- Return the Row of of an address that is a value in a cell
- Returning a value for an actual cell address
- Function to return the letter of a cell-address from a range
- How to return cell address as string inside the cell ?
- Get a cell from the address