View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zy1972 zy1972 is offline
external usenet poster
 
Posts: 7
Default How to get YTD Summary

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 ...