Two lines of text to create tab name and use with Indirect
 

I apologize if this has been asked/answered -- I couldn't find this problem
elsewhere.

Tabs are named "Jan In", "Jan Out", "Jan Static", "Feb In", "Feb Out", "Feb
Static", etc.

B1 & C1 contain text (Jan, Feb)

A2, A3, and A4 also contain text (In, Out, Static)

How can I combine B1 & A2 to use data from the "Jan In" worksheet in a
formula?

I've tried using ONCATENATE and INDIRECT, but either I'm missing
something...or there is a different solution.

-- cp

Two lines of text to create tab name and use with Indirect
 

Hi

The general idea

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

be careful with the singe and double quotes
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"cp" wrote:

I apologize if this has been asked/answered -- I couldn't find this problem
elsewhere.

Tabs are named "Jan In", "Jan Out", "Jan Static", "Feb In", "Feb Out", "Feb
Static", etc.

B1 & C1 contain text (Jan, Feb)

A2, A3, and A4 also contain text (In, Out, Static)

How can I combine B1 & A2 to use data from the "Jan In" worksheet in a
formula?

I've tried using ONCATENATE and INDIRECT, but either I'm missing
something...or there is a different solution.

-- cp

Two lines of text to create tab name and use with Indirect
 

Jeez, eh? I was trying to make it MUCH more difficult! Thanks so much!

"Shane Devenshire" wrote:

Hi

The general idea

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

be careful with the singe and double quotes
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"cp" wrote:

I apologize if this has been asked/answered -- I couldn't find this problem
elsewhere.

Tabs are named "Jan In", "Jan Out", "Jan Static", "Feb In", "Feb Out", "Feb
Static", etc.

B1 & C1 contain text (Jan, Feb)

A2, A3, and A4 also contain text (In, Out, Static)

How can I combine B1 & A2 to use data from the "Jan In" worksheet in a
formula?

I've tried using ONCATENATE and INDIRECT, but either I'm missing
something...or there is a different solution.

-- cp