YTD Match Employee

Hello,

On my 'Paystubs' sheet I'm trying to get the YTD gross pay from the 'YTD Log' for regular hours (times cell F5 for pay rate) and overtime hours (times cell F5 times 1.5) for employee referencing cell E3 for their ID.

My formula in H6 works using helper cells (K3 and K4) but for only the first employee.

Does someone know of a better way?

Thank you so much,
Billy

Thank you but Can they be combined so no helper cells?

I ended up using those cells and restructured thanks for the formulas.