Hi Norbert,

Am Thu, 10 Dec 2020 01:49:52 -0800 (PST) schrieb Norbert:

Hi Claus, I sent you an email from my private account. Up to now, I didn't receive any error. I hope it went through.

the workbook is on the way back to your private account. First I
enlarged the range for "Weekly_Database" to B6:FA505. Then I created the
formula for the customer in cell D8:
=INDEX(WEEKLY_DATABASE,MATCH(B11,INDEX(WEEKLY_DATA BASE,,1),0),MATCH($D$8,INDEX(WEEKLY_DATABASE,1,),0 ))


Regards
Claus B.
--
Windows10
Office 2016