How to use indirect function?

E

Eric

There is the given code,
=RIGHT(LEFT('1'!A3,16),12)
The sheet name is given in cell C2
=INDIRECT("RIGHT(LEFT('"&C2&'!A3,16),12)")
When I try this code, it does not work.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
C

Conan Kelly

Eric,

Put INDIRECT() inside RIGHT() & LEFT().

=RIGHT(LEFT(INDIRECT("'" & C2 & "'!A3"),16),12)


HTH,

Conan
 
D

Dave Peterson

=right(left(indirect("'"&c2&"'!a3"),16),12)
There is the given code,
=RIGHT(LEFT('1'!A3,16),12)
The sheet name is given in cell C2
=INDIRECT("RIGHT(LEFT('"&C2&'!A3,16),12)")
When I try this code, it does not work.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
Click to expand...
 

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

How to use Indirect function? 5
How to count the time? 1
How to use indirect function? 2
How to use Indirect functions? 3
What wrong is it on using the indirect function? 2
How to set the value? 6
Formula Simplifications Using Nested If, Indirect & Address Functi 3
= INDIRECT ("'" & $B$10 & "'!b2") 5

Top