Copy specific cell if the designated cell contains text from a certain category

Hi,

I have a complicated question:

I am working on an automated document that, whenever someone chooses a word from the dropdown list, most of the other info is automatically filled in.

For example: Column 1 (main column) contains the car brand, Column 2 contains which country it originates, Column 3 contains the manufacturer, etc.

Is there a formula for this?

That solved my problem!

Thank you for your help and fast relpy!