I need to look at a lead time in weeks from column B and locate that
week in a seperate table - then sum the values in that table from the
beginning to that found week. Example:



Weeks 1 2 3 4 Rate 1 1 2 2
Weeks # of Boats
3 Need Formula
4
2
4
The above should return the value of 4 - One in week 1, One in week 2,
and two in week 3.

Thanks
-Steve

Please look at your question and ask yourself if anyone could answer it
without knowing how your data is set out. We DO want to help but are not
mind readers.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

" wrote in message
...
I need to look at a lead time in weeks from column B and locate that
week in a seperate table - then sum the values in that table from the
beginning to that found week. Example:



Weeks 1 2 3 4 Rate 1 1 2 2
Weeks # of Boats
3 Need Formula
4
2
4
The above should return the value of 4 - One in week 1, One in week 2,
and two in week 3.

Thanks
-Steve