automatic transfer

[td90]

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

[Pete_UK]

If you have a list of companies in column A of Sheet2, then in column B you can add the appropriate distances to each one. Assuming you enter the destination in cell A2 of Sheet1, then you can use this formula in B2:

=IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))

although, as you are in Belgium, you may need to use semicolons ( ; ) instead of commas ( , ) in the formula, as well as translate the function names, depending on your regional settings.

Hope this helps.

Pete

[td90]

I've got it, thanks for your help :D


I had been looking around for this function for 2 weeks.

Thanks allot! :D

I also wish you a nice Christmas and a happy new year :D

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.