Dynamic lookup with index & match

Question

Link to google sheet

I am would like to use the values in the name column (search key) and look them up in a table with the headers [name, regular, overtime]. The formula I am using is

=ArrayFormula(index(rateTable, match(formName,workers,0),match(formType,rateTypes,0),0)*{formHours})

It works except the search key in the MATCH formula, does not reference every respective entry in the name column, but only works with one fixed reference to a cell.

Am I trying to use this formula beyond its capabilities? I'd like to know if I should stop searching. Thanks.