Based on the month entered in the summary sheet cell G5 , I want to
have the cumulative YTD budget returned next to each indicatior.
Summary Sheet
Cell G5 "Enter month"

Column C Column D
Indicator A lookup(columnC... return YTD budget based on month
in G5) *
Indicator B
Indicator C

Budget Sheet
cell above month number has formula
{if(monthnumber<=month,g5 else ""
1 2 3 4
Indicators April May June July
Indicator A 20 25 27
Indicator B

*bit Im having trouble with

Dave F wrote:
What's the lookup involved?

As I understand your question, you are summing via a month entered in G5.

What do you want to do after that--copy the value to the summary sheet?
--
Brevity is the soul of wit.