Finding a specific cell in a spreadsheet

Hi All,

I am building a sales report, i have a worksheet with all my sales people's budgets broken down by month.

A B C D E F G
1 Jan Feb Mar Apr May Jun
2 Jim 10 10 10 10 10 10
3 Tom 8 8 8 8 8 8
4 Bob 7 7 7 7 7 7

In a separate worksheet i have a "sales wrap" and need to capture the budget for that sales person for that month.

I also will also need to capture the cumulative budget for that sales person upto and including that month.

Sorry for the confusion.

You have found exactly what i want, for some reason though, I keep getting #N/A as a result. Is it something to do with the formatting of the months, i have them as text.

I would also need to figure out the sum YTD, which ideally should show 24