CODEWITHSUNDEEP
excelvbadateexcel-formula
user8879699
user8879699

Reputation: 1

Use Cell info in a formula

I was wondering if it's possible to use info from a cell in creating a formula. Here's the situation;

A1 = Date (01/01/17)
A2 = Month from that date (January)

I have different worksheets in the book for every month so for January the sheet is called January.

Is it possible to create a formula where I can reference a cell in a page that corresponds to the month in A2.

So for example in A3 the formula would be =January!A1

But instead of Jan I want it to be dynamic so it would change to any month depending on what I input in previous cells.

Upvotes: 0

Views: 88

Answers (1)

barry houdini
barry houdini

Reputation: 46341

In A2 to get the month try

=TEXT(A1,"mmmm")

and then in A3

=INDIRECT(A2&"!A1")

or you can cut out A2 altogether and use just

=INDIRECT(TEXT(A1,"mmmm")&"!A1")

Upvotes: 3

Related Questions