Hey folks, I've run into a bit of a conundrum, and I'm hoping you can help me. I have a chart that lists various employees, and how much they charge for 3 different types of clients.
The three types of clients are large, medium, and small businesses, and each of 14 different employees bill a different rate for each size client.
Employee Large Medium Small
Adam 100.00 80.00 75.00
Becky 200.00 150.00 100.00
Clair 75.00 75.00 50.00
What we would like to do is be able to check a box (or put an "x" in it), and use a drop down menu to select which employee we are charging for. So I check a box for medium, and select Clair from the drop down menu, and I want her "75.00" to populate in the cell. I'm thinking this might involve some complicated IF/Then statements, or creating a separate worksheet to work out the possible combinations, but I'm a little stuck on how to do it.
Any help would be much appreciated.
The three types of clients are large, medium, and small businesses, and each of 14 different employees bill a different rate for each size client.
Employee Large Medium Small
Adam 100.00 80.00 75.00
Becky 200.00 150.00 100.00
Clair 75.00 75.00 50.00
What we would like to do is be able to check a box (or put an "x" in it), and use a drop down menu to select which employee we are charging for. So I check a box for medium, and select Clair from the drop down menu, and I want her "75.00" to populate in the cell. I'm thinking this might involve some complicated IF/Then statements, or creating a separate worksheet to work out the possible combinations, but I'm a little stuck on how to do it.
Any help would be much appreciated.
