Need a formula where if today's date equals December, C5 will return $400,000 automatically

[Ameratsu]

I have a list of monthly balances that gets updated automatically, I am trying to create a formula to automatically show this month's balance.

If today is December, C5 returns the monthly balance automatically which is $400,000

Thanks

sample (1).xlsx
	B	C
3	Today's Date	12/3/2022
4
5	Current Price
6
7	JAN	$250,000
8	FEB	$270,000
9	MAR	$260,000
10	APR	$280,000
11	MAY	$300,000
12	JUNE	$320,000
13	JULY	$330,000
14	AUG	$360,000
15	SEPT	$380,000
16	OCT	$390,000
17	NOV	$380,000
18	DEC	$400,000
Sheet1

 

[hajiali]

Try

 =INDEX($C$7:$C$18,MATCH(TEXT(C3,"MMM"),$B$7:$B$18,0))

 

[alansidman]

=VLOOKUP(TEXT(B1,"mmm"),A5:B16,2,FALSE)

I assumed your data was in columns A:B

 

[decent_boy]

Please try below

Book1
	A	B
1	Today's Date	12/3/2022
2
3	Current Price	400000
4
5	JAN	250000
6	FEB	270000
7	MAR	260000
8	APR	280000
9	MAY	300000
10	JUNE	320000
11	JULY	330000
12	AUG	360000
13	SEPT	380000
14	OCT	390000
15	NOV	380000
16	DEC	400000
Sheet1

Cell Formulas
Range	Formula
B3	B3	=VLOOKUP(TEXT(B1,"mmm"),A5:B16,2,0)