Hi Frank,

Am Fri, 23 Mar 2012 02:26:53 -0700 (PDT) schrieb Frank:

A simple LOOKUP will not identify a value between 2 dates,
unfortunately.

your searched ProductID in F1 and the OrderDate in G1. Then you find the
price with:
=INDEX(List1!C:C;VERGLEICH(1;(List1!A1:A100=F1)*(L ist1!B1:B100<=G1);0))
The formula is an array-formula to enter with CTRL+Shift+Enter.

Warum schreibst du nicht in den deutschen Newsgroups?
microsoft.public.de.excel
de.comp.office-pakete.ms-office.excel


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