Using Input in one cell to pull from various

Microsoft Office excel 2007 - upgrade
May 21, 2010 at 11:21:03
Specs: Windows XP
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?

See More: Using Input in one cell to pull from various

May 21, 2010 at 11:35:03
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


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.

Report •

May 21, 2010 at 11:50:43
That is exactly what I was looking for!!! Thank you!!!!

Report •
Related Solutions

Ask Question