I am not sure if the lingo I am using is correct, but I can explain the problem I am having and hopefully someone can help.
I manage a valet and I am trying to keep track of parking productivity. I have a table with a column that lists all the valets names and a column that lists how many cars they parked in one day. My goal is to have a column that calculates how many cars they park per hour. The problem is that each of the valets work a different number of hours per day depdending on the day of the week. So, I have a different table that has a column with each of the valet's names and a separate column of each day of the week that lists how many hours they work that day. I need a formula that can check the day of the week, then choose the proper column to get the hours worked for that day, match to the correct valet name, and then divide the number of cars parked that day by the number of hours worked. Does that make sense? I figure it must have something to do with a vlookup?
Thanks,
Spencer
I manage a valet and I am trying to keep track of parking productivity. I have a table with a column that lists all the valets names and a column that lists how many cars they parked in one day. My goal is to have a column that calculates how many cars they park per hour. The problem is that each of the valets work a different number of hours per day depdending on the day of the week. So, I have a different table that has a column with each of the valet's names and a separate column of each day of the week that lists how many hours they work that day. I need a formula that can check the day of the week, then choose the proper column to get the hours worked for that day, match to the correct valet name, and then divide the number of cars parked that day by the number of hours worked. Does that make sense? I figure it must have something to do with a vlookup?
Thanks,
Spencer