I do not know if this is already somewhere in a topic.

how do you do an automatic transfer to a 2nd column?
example if you are going to deliver at a company then you indicate the company in the first column and the 2nd column automatically gives the number of kilometers.
I use data validation in the first column.
the companies are on a different sheet in the same file.


Nike = 85 km
Coca Cola = 30km
Audi = 30km
samsung 150km