Referring to cells by range names

  • Thread starter Thread starter rllane47
  • Start date Start date
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
 
=INDIRECT(Q5) INDIRECT(T3)

Space after (Q5)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

Back
Top