Vlookup doesnt work here, is there another formula?

[abav]

Hi there,

I have tried a Vlookup however it didn't get the data i wanted, it seemed to be only able to match parts of the data and would bring over incorrect pricing.

Is there another formula that would help here?

So in the attachment on the left you can see the information and pricing that i need to move over to the right pricing column while matching it to incomplete reference data.

So price for 225/55R17 96W is 100, on the system its 225/55R17 W the Vlookup is getting confused here, is there another formula that would work here.