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

C

cp

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
 
S

Shane Devenshire

Hi

The general idea

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

be careful with the singe and double quotes
 

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

Use Text and Cell vale to reference a named range inside a formula 4
Combining Text From Cells 3
Use of the Contents of a cell as a worksheet name in a function 3
CONCATENATE text to create a formula to be evaluated 2
Conditional Formatting, Dates, and "Fill Column" 2
Use Vlookup to store formulas? 6
Use of INDIRECT and quotation marks 1
Not sure which function to use in this instance. 4

Top