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

Report •

#1
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

=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.


Report •

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

Report •
Related Solutions


Ask Question