I'm sure this topic has been covered already.... but I didn't even know how to search the forum for my question.....
Example of my data:
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Etc....
I need to create an excel function (I assume index and match) so that in another sheet:
Job# Name Shift Type Rate #Hrs Labor$$
xxxxx John Shift 1 OT (1-15) 6 HrsxRate
If I manually enter in the Job Number, Name, Shift, Type & #hrs, the Rate (1-15) will spit out.
The function will need to search the name column and the shift column and spit out the correct row....
Any help would be much appreciated! Thank you.
Example of my data:
Name | RG | OT | DT | |
John | Shift 1 | 1 | 2 | 3 |
John | Shift 2 | 4 | 5 | 6 |
John | Shift 3 | 9 | 8 | 7 |
Max | Shift 1 | 10 | 11 | 12 |
Max | Shift 2 | 15 | 14 | 13 |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Etc....
I need to create an excel function (I assume index and match) so that in another sheet:
Job# Name Shift Type Rate #Hrs Labor$$
xxxxx John Shift 1 OT (1-15) 6 HrsxRate
If I manually enter in the Job Number, Name, Shift, Type & #hrs, the Rate (1-15) will spit out.
The function will need to search the name column and the shift column and spit out the correct row....
Any help would be much appreciated! Thank you.
Last edited: