I am having an issue in a file where I have three sheets and I am attempting
to combine VLOOKUP results into the third sheet.

The second VLOOKUP does not appear to be working correctly.