Return value for matching name

[Busjedwa30]

I need to check the corresponding hourly rate for each person named in the rates tab, and return in yellow cell in column I on sheet one.

[Busjedwa30]

I have figured it out I think ... =INDEX(Rates!D:D,MATCH(B15,Rates!A:A,0))

[JohnTopley]

Please mark thread as solved ("Thread Tools" at top of first post)