Hi, welcome to the forum

This is where I run into trouble with a simple VLOOKUP, as this can only look at one of the values and check whether they are the same.
Not strictly true, columns and cells can be combined for the search

Give me a few minutes and I will come up with something for you