I need help on a formula where I find an item and quantity based on a specific date

Hi All,
I am looking to find a formula where I am looking for a specific item then finding the quantity that matched up to the date counted. which auto fills each week
This information would show on a new tab to mail out
for example: shoes size 3 for week one (or date) have a quantity of 11 and that quantity would change for ongoing weeks.
It's possibly a simple formula for some but I can't seem to grasp it.
I was thinking of a vlookup them the range but its the change of date to adjust the week concerned that is foxing me,
Any help would be greatly appreciated