Hi Miko,

If you intended to get the highest week number which is greater or equal to
the starting weeks for a given product, then:

Assume that your Product/Price/Starting Week-List is in cells A2:C7 (insert
an additional entry with price 15 and starting week 1 for product 6919), then
write your search product number into E2 and your search week into F2.

G2 will give you the correct starting week and should read:
=MAX(IF((E2=A2:A7)*(F2=C2:C7),C2:C7))
[enter as array formula with CTRL+SHIFT+ENTER]

H2 will give you the correct prive and should read:
=MAX(IF((E2=A2:A7)*(F2=C2:C7),B2:B7))
[enter as array formula with CTRL+SHIFT+ENTER]

HTH,
Bernd