Good morning.

I'm fairly ignorant when it comes to Excel, but trying to learn as I go...Here's my question..

I have a two sheet workbook, First sheet has dates, employees, number of hours worked and a pay rate. Second sheet has a two columns with the employees name and hourly pay rate.
I was able to create a drop down on the first sheet so I could select an employee. What I'm trying to figure out is, how to take the matching pay rate from second sheet, and have it populate the corresponding column on the first sheet.
For example, I pick John Smith from my drop down, I'd like John Smith's pay rate to fill in automatically from the data on the second sheet.

I hope I am asking the question the right way.. Like I said, still trying to wrap my head around the finer points of Excel

Thanks!

Jim