I have tabs for january through December. On the 13th tab, I would like to include a cell, where I can type the month and have all formulas on that sheet use the information found on that corresponding tab. (i.e. if I wanted income from a certain month, I can type the month name into one cell and have it pull from that month's tab) Can this be done?

The INDIRECT funtion will do that for you. Let's say you want to pull a value from January!C1 into Sheet13!C1.

In Sheet13!C1 enter:

=INDIRECT(A1 & "!C1")

When you enter January in A1, the formula will evaluate to

=January!C1

You can build formulas with INDIRECT also.

With Month Names in A1 and A2, this will multiple the values in the referenced cells:

=INDIRECT(A1&"!C2") * INDIRECT(A2&"!A2")

P.S. I would use a Drop Down to choose your month names so that typos don't screw up your formulas.

I hope that helps.

That is exactly what I was looking for!!! Thank you!!!!

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History