I have data in a sheet for the months. I want the user to be able to put in the number of the month they want (i.e. "4" for "April") in a cell, and have a formula return a value for the Month and YTD amount (i.e. January-April).
I don't want to have 12 different columns for YTD numbers, so I'd like the formula to look at the month the user input then use that to determine the YTD amount.
Maybe Vlookup isn't the best way. Any suggestions would be appreciated.
Sample file is attached (note, this is a very simplified example of what I need. The actual data has hundreds of lines.).
Using Excel 2010.
Thanks in advance!
David
Bookmarks