Timetracker formula
Hello,
I have a timetracker and have 2 problems:
 For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours1
 When I remove the first entry which was a test, it messes up the calculation on the ones below the rate table. It gives me an #UNPARSEABLE message.
I have attached the image of the sheet
Thanks
Answers

Are you able to provide a screenshot that shows more of the sheet including your column names and row numbers?

Yes sure. Here it is

And I assume your formulas you want to actually use are in rows 12 down?
=VLOOKUP([Talent/Materials]@row, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours@row
Using the @row reference tells the formula to evaluate based on the data that is in the specified column in whichever row your data is on. It may be that the formulas in the lower rows have an incorrect row number.

Ok I see. Let me try that out. Thanks

It worked. Thank you

Happy to help! 👍️
Please don't forget to mark the most appropriate response as "helpful". That way others looking for a similar solution can know that one may be found here.
Help Article Resources
Categories
Check out the Formula Handbook template!