Z
zy1972
Hi,
I have a 12-m sales number. I know it is easy to get MTD number by using
vlookup, but is there a way to get YTD number when month changes?
For example, if I use a cell to input month, then use vlookup to get a
number. Then this number is used in vlookup to get MTD number. Could I use
the Month Input to get a YTD number. for example, if I put April , MTD shows
7, and YTd shows37?
A1 A2
A13
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales 12 13 5 7 8 9 10 11 1 2 3 6
D1 D2
Jan 2
Feb 3
Mar 4 ...
I have a 12-m sales number. I know it is easy to get MTD number by using
vlookup, but is there a way to get YTD number when month changes?
For example, if I use a cell to input month, then use vlookup to get a
number. Then this number is used in vlookup to get MTD number. Could I use
the Month Input to get a YTD number. for example, if I put April , MTD shows
7, and YTd shows37?
A1 A2
A13
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales 12 13 5 7 8 9 10 11 1 2 3 6
D1 D2
Jan 2
Feb 3
Mar 4 ...