2 criterias to organize data by VLookup

Sorry, you're right, I missed them

Anyway, since there are too many variables, and you have all of your data organized this way(every company and every car is on the same table), the solution is a little bit complicated. I had to follow several steps to do it, and these steps maybe may scare you, however, with the data organized this way, I don't see any other solution. (p.s: if following these steps is too hard for you, you could also prefer to write a vba code for these steps.)

See the uploaded workbook.