Look up multiple columns in table to get value


I’m not a programmer.

I’ve got a column in a table where I’ve got the hours someone’s worked. I want to get their wages by multiplying hours worked x “wage grade” (the wage grades are listed in a separate table).

I feel like this should be easy to do, but I can’t figure it out.

I feel like it should be easy to be like =“hours worked”*“wage grade”(filter for grade in separate table)


here is a solution;

I hope this helps.