Calculate salary based on badge ID/hours on one sheet, badge ID/Rate another sheet.

This is so simple it is making me crazy

I need to lookup a badge id from one sheet to another, then return the charge by multiplying the rate x hours worked.

First, I added a column on "Detail sheet" titled rate and used vlookup to return the rate and then B2*rate column to give me the charge. I would rather not have the rate show on my Detail sheet, so I attempted using index and match, and got in a pickle.

Any help will be greatly appreciated!

In D2, try this:
=INDEX(Rate!$B$2:$B$7,MATCH(A2,Rate!$A$2:$A$7,0))*B2

Thank you so very much!!! I was trying to use 2 match instead of just closing off and *B2

You're welcome, and thanks for the rep.