Forum Discussion
Tracking Profit
Let's say you create a new worksheet in the same workbook and name it Rates.
In A1, enter Employee and in B1, enter Hourly Rate.
In A2, A3 etc., enter the names of the employees (Jonathan etc.).
In B2, B3 etc., enter the corresponding hourly rates.
Go back to the profit sheet.
Enter the following formula in T2:
=J2-I2*IFERROR(VLOOKUP(P2, Rates!$A$2:$B$1000, 2, FALSE), 0)
If you want to take multiple crew members into account, please provide more detailed information about the setup.
Where is Jonathan's hourly rate stored?
- Can it pull from another spreadsheet within the same workbook?
What if there's multiple crew members on the same job?Let's say you create a new worksheet in the same workbook and name it Rates.
In A1, enter Employee and in B1, enter Hourly Rate.
In A2, A3 etc., enter the names of the employees (Jonathan etc.).
In B2, B3 etc., enter the corresponding hourly rates.
Go back to the profit sheet.
Enter the following formula in T2:
=J2-I2*IFERROR(VLOOKUP(P2, Rates!$A$2:$B$1000, 2, FALSE), 0)
If you want to take multiple crew members into account, please provide more detailed information about the setup.
HansVogelaar I've entered the formula suggested and this is what shows up. I've also included a screenshot of the rates spreadsheet as well. It doesnt seem to be working. I know on two of them there are blanks in the Crew Leader column, but the others, "David", "Elias", "Josue" and "Miguel" are all input on the rates spreadsheet. Do you see something I'm doing wrong perhaps?
