Excel quotation

K

KathyIris

I want to quote value of a cell on differnt tabs, location of the cell is
defined in column B. Now i have

A(tab name) B C
1 aaa H121
=INDIRECT("'" &A1& "'!H121")

How can C1 use B1 in the formula instead of calling "H121" out directly?
 
D

Dave Peterson

=indirect("'"&a1&"'!"&b1)


I want to quote value of a cell on differnt tabs, location of the cell is
defined in column B. Now i have

A(tab name) B C
1 aaa H121
=INDIRECT("'" &A1& "'!H121")

How can C1 use B1 in the formula instead of calling "H121" out directly?
 
R

Rick Rothstein

In the same way A1 was included... you just concatenate the text values you
need (if they are in a cell, like the contents of A1 was, you just use the
reference to the cell)...

=INDIRECT("'"&A1&"'!"&B1)
 

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

Top