I have this scenario:

Product_ID Product_Price Starting_Week
154 10 1
6919 15 32
6919 16 34
154 12 33
6919 17 36

Given a ProductID and a Week I need to return the price for that Product_ID
in that specific week or if the specific week doesn't exist I must return the
price for the closest week.
Per Examples:
- If ProductID=6919 and Week= 33 I must get the price for the ProductID=6919
Week=32 (15)
- If ProductID=6919 and Week=1 I must get the price for ProductID=6919 Week=32
- If ProductID=154 and Week= 3 I must get the price for ProductID=154 Week=1
- If ProductID=154 and Week=35 I must get the price for ProductID=154 Week=33

I have tryed with:
- Vlookup (adding a index column with Product_ID&Starting_Week)
- INDEX/MATCH
- Array Formula with INDEX/MATCH

and nothing is working... I really need you help with this... please

I will appreciate your help

Miko