Referring to cells by range names

R

rllane47

cool.
half way there.
now if i go to another page and want to refer to the cell "a john", bu
i want to use another cell to pull the "a" and the "john", how do i d
that? let us say that the matrix aboce is in the array a1:d4. th
theory here is that i want to create a report by typing john, mary o
pete into a cell (for this exercise, cell q5) and typing either a, b o
c into another cell (for this exercise, t3), and then typing a formul
in cell t5 that references q5 and t3 but returns the same value as if
had typed "a john
 
N

Niek Otten

=INDIRECT(Q5) INDIRECT(T3)

Space after (Q5)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top