How do you Sum the range of two lookup values?
 

This is my lookup function.
=LOOKUP("Next Accrual",A5:A25,C5:C25)
I need a formula that will add the range from C5 to the point where this
lookup function is satisfied.

How do you Sum the range of two lookup values?
 

Hi
try:
=SUM(OFFSET($C$5,0,0,MATCH("Next Accrual",A5:A25,0)))

--
Regards
Frank Kabel
Frankfurt, Germany


Sum the range of two lookup values? wrote:
This is my lookup function.
=LOOKUP("Next Accrual",A5:A25,C5:C25)
I need a formula that will add the range from C5 to the point where
this lookup function is satisfied.