I have a series of sheets named: JAN 2022, FEB 2022, etc. I have a cell that is pulling E2 from the sheet as ='JAN 2022'!E2

I want to pull the E2 value for the current month. I tried using the following, but it doesn't work: ='(CONCATENATE(TEXT(today(),"mmmm")," ",2022)'!E2

Please advise.

CodePudding user response：

Give this a try

=INDIRECT(text(today(),"mmm "&2022)&"!E2")

CodePudding user response：

try: =indirect(upper(text(today(),"mmm yyyy"))&"!E2")