Excel: find next smaller number in a column with duplicates for a given number value

I have a Table1 with data set that contains year (Column A), week (Column B) and values (Column C). I want to get the next smaller week in D4 for a given week in Cell D2 and year in D3 i.e. if D2 = 23 and D3 = 2020 the function should return D4 = 20 based on example data below. The thing is there is duplicate years' and weeks' which makes the following functions not work:<br>

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This whopper I found on this forum sadly only returns the 2nd largest value in a column with duplicates (I am not allowed to post a link):

Please Login or Register  to view this content.

Data set in Table1

Please Login or Register  to view this content.

Can someone please help to create a function that can look up the next smallest week after a given week in a year?

Hi, thanks for your reply. Yes I can.
I clicked the Manage Attachment and Uploaded the file. I closed the Manage Upload tab, but don't see my file. The file is only 35KB.
Do you know how to complete the upload?

Okay. I have followed the instructions and although the file shows in the Current Attachments section of the Manage Attachments tab.
It does not show in the Attachments dropdown in the Post toolbar. It just appears...

How can I broaden my explanation to give you more information? See attached.