Time-tracker formula

Chichi

Hello,

I have a time-tracker and have 2 problems:

1. 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
2. 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

Screen Shot 2020-03-24 at 12.49.41 AM.png

Thanks

Paul Newcome

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

Chichi

Yes sure. Here it is

Screen Shot 2020-03-24 at 10.33.57 AM.png

Paul Newcome

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.

Chichi

Ok I see. Let me try that out. Thanks

Chichi

It worked. Thank you

Paul Newcome

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.