Need to figure out how to get a vlookup to go back and find the next match in an if statement that ends up false

I'm trying to lookup a part number in a list and check to see if the weeks it was on sale matches so I can bring in the promotion title. If the weeks don't match, I want to be able to have the vlookup find the next instance of the part number in the list to see if it was on a different promotion later in the year and if my weeks match with that promotion.

Is it possible to next lookups so that it will keep going back to find the next instance of a value or will it only ever just start at the top and find the first?