ExcelBanter - Reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Reference (https://www.excelbanter.com/excel-worksheet-functions/35159-reference.html)

tjh

Reference

Hello,

I have several cells that use a formula to combine letters and numbers. Such
as cell A22 displays a value of E7.

In cell B22, I would like to use the value in cell A22 (Which is E7) to
reference the value in E7. How should I do this?

Duke Carey

Use

=INDIRECT(A22)

"tjh" wrote:

Hello,

I have several cells that use a formula to combine letters and numbers. Such
as cell A22 displays a value of E7.

In cell B22, I would like to use the value in cell A22 (Which is E7) to
reference the value in E7. How should I do this?

All times are GMT +1. The time now is 12:05 PM.