Auto Populate Lists in Excel with Service, Gross, Net and Profit

You can approach it from two ways:

A VLOOKUP() or Vertical-Lookup is a database function, meaning that it works with database tables – or more simply, lists of things in an Excel worksheet http://www.howtogeek.com/howto/13780...okup-in-excel/

The function (or combination of functions) I used in your workbook were INDEX/MATCH. It also functions as a database function (when used together), but is more robust than VLOOKUP() in that you can perform matrix lookups http://www.randomwok.com/excel/how-to-use-index-match/

The lookup essentially takes a cell, looks through a range of cells for a match to the previous cell, and returns the value of a cell associated with the initial range (within the same row/column).

Dear excel genius, by the time I figure all of that I will probably have missed all of 2016 (LOL). I am hoping you will give me a holiday miracle and help me with the example that is attached (please). As per our previous conversations for the billing form I want to have a drop down of the TPI Employee Names and also when I pick a service I want the gross and net rates to come up in the billing form (so that when I add the hours "the variable" it will calculate the gross and net rates and profit) and then for the invoice I want to use the service and the gross from the same lists to come up in the invoices. If you could help me with this it would save me so much time in 2016 and give me some time to enjoy my life a bit!

There is an actual job (Hunter) attached that we can use as our first example (please)!

Thank you so much for your help!