Search list of data, if one of multiple criteria found, give value to cell x VBA

As I could not find anyone posting something like this, I make this question.

I have some data that is "dirty" and I need to clean it. In the picture in the link you can see a list of cars Column A is correct but the rest is wrong

I would need a code that could search Column A for information and then input the correct information into column F, G, H, I in similar way as shown in the picture

The dataset would be over 10000 lines

If the code could be customizeable also so that we could add more criterias that would be very helpfull

Thank you so much for replies.

Regards

Table in question