How to calculate hours based on individual daily rates
Requirement:
The user is trying to get a formula to look at a range of names, look up a name in another range and then calculate the hours used based on the number of days x a their daily rate.
The following is a sample:
Solution:
In E3 of Sheet1 put
Code:
=IF(ISNA(MATCH(A3,Names,0)),"No Match",PRODUCT(D3,INDEX(Sheet2!D:D,MATCH(Sheet1!A3,Names,0)+4)))
The following will also work:
In E3
Code:
=IFERROR(VLOOKUP(A3,Sheet2!$B$4:$D$8,3,0)*D3,"")
and copy down.
Obtained from the OzGrid Help Forum.
Solution provided by crushdrinker06 and sktneer.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to calculate overtime on Timesheet after 10 hours per day AND/OR 44 hours per week |
| How to drag every Nth column, with varying starting column by date |
| How to use a VBA code to change cells colours based on date in other cells |
| How to count non blanks 5 years from the last non blank date |
| How to use SUMPRODUCT with dates |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
