Hi Norbert,

Am Wed, 9 Dec 2020 04:58:00 -0800 (PST) schrieb Norbert:

and the range WEEKLY_DATABASE is: =weekly!$E$6:$FA$505

try:
=INDEX(WEEKLY_DATABASE,376,MATCH(D8,INDEX(WEEKLY_D ATABASE,376,),0)+1)


Regards
Claus B.
--
Windows10
Office 2016