Hi again,

Am Tue, 30 Oct 2012 10:02:14 +0100 schrieb Claus Busch:

pls look again for the workbook. I changed it for your expectation

if you are at work and can't lool for the workbook:

Your Lookup date in C11
in E11:
=SMALL(OFFSET($C$1,MATCH($C$11,C2:C10,0),2,COUNTIF (C2:C10,$C$11)),ROW(A1))
in D11:
=INDEX(D$2:D$10,MATCH(C11&E11,$C$2:$C$10&$E$2:$E$1 0,0))
in F11:
=INDEX(F$2:F$10,MATCH(C11&E11,$C$2:$C$10&$E$2:$E$1 0,0))

The formulas in D11 and F11 are array formulas to enter with
CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2