Excel: Help with a pretty simple spreadsheet.

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. [IMG]http://s28.postimg.org/ekv5x62n1/image.jpg[/IMG] [IMG]http://s29.postimg.org/jgclw4nxz/image.jpg[/IMG] [IMG]http://s29.postimg.org/4ab5ixnav/image.jpg[/IMG] 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.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of May 29, 2015.

For more resources for Microsoft Excel