ExcelBanter - How to use indirect function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to use indirect function? (https://www.excelbanter.com/excel-discussion-misc-queries/178251-how-use-indirect-function.html)

Eric

How to use indirect function?

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

Conan Kelly

How to use indirect function?

Eric,

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

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

HTH,

Conan

"Eric" wrote in message
...
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

Dave Peterson

How to use indirect function?

=right(left(indirect("'"&c2&"'!a3"),16),12)

Eric wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 06:52 PM.