# Thread: look for values base on =Today() Thanks: 0 Likes: 0

1. ## look for values base on =Today()

 A B C D E F G H I J K L M N 1 item1 Aug. Sep. Oct. Nov. Dec. 2 item2 item1 100 200 300 1 2 3 item3 item2 50 20 40 4 7 4 item3 85 58 5 6 7

Dear Pros,

I would like cell "B1" for "item1" to auto look for the value base on the month of "=TODAY()",
i understand that it is not possible to do it with vlookup function,

Please suggest on how to do this, thank you~

2. ## Re: look for values base on =Today()

Hi, assuming the month names in J1:N1 are text and include the full stop / period, you can try..

Excel 2013/2016
ABCDEFGHIJKLMN
1item1100Aug.Sep.Oct.Nov.Dec.
2item250item110020030012
3item385item250204047
4item38558

Sheet1

Worksheet Formulas
CellFormula
B1=INDEX(\$J\$2:\$N\$4,MATCH(A1,\$I\$2:\$I\$4,0),MATCH(TEXT(TODAY(),"MMM."),\$J\$1:\$N\$1,0))

3. ## Re: look for values base on =Today()

Originally Posted by FormR
Hi, assuming the month names in J1:N1 are text and include the full stop / period, you can try..

Excel 2013/2016
A B C D E F G H I J K L M N
1 item1 100 Aug. Sep. Oct. Nov. Dec.
2 item2 50 item1 100 200 300 1 2
3 item3 85 item2 50 20 40 4 7
4 item3 85 58
Sheet1

Worksheet Formulas
Cell Formula
B1 =INDEX(\$J\$2:\$N\$4,MATCH(A1,\$I\$2:\$I\$4,0),MATCH(TEXT(TODAY(),"MMM."),\$J\$1:\$N\$1,0))
Thank you sir, you are awesome with such prompt response