I'm building a job quoting calculator and I need a cell to reflect the billing rate of the employee that I choose from the dropdown list in the adjacent cell e.g. if I select the name Jim from the dropdown list, his rate of 50 automatically populates in the cell to the right. I am using two sheets, the first is the clean and pretty calculator that looks like a form and the second that contains all of the data fields for the dropdown lists that I have on the first sheet (employee names, their billing rates, job types, etc). I've figured out how to use an IF statement but I need to be able to select from 20+ employees and don't want to type out a mile long IF statement in order to make it work. I've just started looking into VLOOKUP but I'm fairly confused and I'm not sure if that's what I need. Can anyone help me out with what I need to make this work?
Bookmarks