Indirect or Index or something else

J

Jambruins

In column A I have text and I also have a sheet that corresponds to the text
in column A. For example, in cell A2 I have ARZ and there is also a sheet
called ARZ. I would like a formula in cell B2 to go into the sheet called
ARZ and pull the text from cell R1. Any idea how to do this? Thanks.
 

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

Similar Threads

Help to create a macro 2
Excel If a Cell Contains a Certain Text (From Another Table) 0
Using INDIRECT Function and INDEX Function 1
Continuous Invoice Nos. 3
display text in a cell in a range of cells 1
Duplicate "Drag" feature 2
use of the indirect function? 4
How Do I Make Vlookup Continue Looking 0

Top