Help with a pretty simple spreadsheet.

[rinzler]

Hi, Im feeling really stupid since i can't figure this out. Ill explain and post some Pictures and hopefully itll be clear enough that some genius can help me.

I have a workbook that i use for recording service jobs. So its pretty simple looking: i have a few colums with Customer, Typ of job, Products used and number of miles ive driven.

The workbook contains two spreadsheets one with all my hours recorded and one with the customer and how far it is there and back to the customer.

I want that on spreadsheet one when i pick the customer from a drop down list that it automatically filles in the miles corresponding to the customer, ill provide some Pictures to help explain.

How do i accomplish this? I allready have the drop downs setup to get the customer name from the spreadsheet named Mil, but now i don't know how to get it to display the miles when i choose the customer.

 

[gaz_chops]

Hi, welcome to the forum.

Try

=vlookup(C2,Mil!$A$2:$B$100,2,0)

Edit : you may need to change , to ;

=vlookup(C2;Mil!$A$2:$B$100;2;0)

 

[rinzler]

Hi, now it returns #NAME? with the 2nd string you posted. Not really sure what that means

 

[gaz_chops]

Sounds like you haven't copied and pasted the formula correctly!

 

[rinzler]

I copied it exactly like you wrote it.

Here look.

 

[gaz_chops]

Mmm, is the name of the sheet Mil just Mil or are there any spaces etc?

Try
=vlookup(C2;'Mil'!$A$2:$B$100;2;0)

 

[rinzler]

Hi, i translated it to the Swedish version and now it works, forgot to mention i have a Swedish Excel installation. Thank you so much !

 

[gaz_chops]

You're welcome, didn't think of that!!

 

[rinzler]

Next uestion is, how do i get excel to auto fill the miles field regardless of which customer name is in the other cell? Now i have to manually Point it.

 

[gaz_chops]

Not sure I understand, if you change the Customer from the dropdown, the miles will auto change.