Auto populate a column based on a drop down choice from another column ?

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

Just saw that I did.. I apologise! Here it is

Originally Posted by Naveed Raza

now check it out

WOW! Thank you very much.. Precisely what I was trying to do!!! I really need some type of schooling on this, if I'm expected to continue working with Excel.

Have a great day