Help with auto adjusting date formula

**BRISBANEBOB** · 04-06-2009, 08:22 PM

Hi

This should be simple but I can't get it...any help appreciated. See sample attached

**shg** · 04-06-2009, 08:32 PM

D2: =index(f12:q12, match(d$11, f$11:q$11, 0))

**BRISBANEBOB** · 04-06-2009, 08:37 PM

Sorry - not sure how I would use that to correct the #ref in cell D12...

**c_m** · 04-06-2009, 08:44 PM

Try in D12:
=SUM(OFFSET(F12,,,1,MATCH($D$11,$F$11:$Q$11,0)))
and copy down

**shg** · 04-06-2009, 08:47 PM

Sorry, the formula goes in D12, and then copied down. Or maybe c_m has what you want ...

**BRISBANEBOB** · 04-06-2009, 08:48 PM

Sorry - I worked that out myself after 30 seconds. Thanks for yoru help

**shg** · 04-06-2009, 11:58 PM

You're welcome. Mark us up as Solved, please.

Re: Help with auto adjusting date formula