Thread: Reference
View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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?