determinedtoexceed
New Member
- Joined
- Aug 20, 2019
- Messages
- 38
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 |
<tbody>
</tbody>
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~