How to Return Column Data Based on Matching Row Data in First and Second Worksheets

Hi All,

I am not really sure how to explain what I want to accomplish, but I believe what I am looking to do is possible with INDEX and MATCH. Basically, I have a column of data on one worksheet that is also the same of one of the columns of data on another worksheet. The similar data would be usernames. On the second worksheet there's also a column of data that I had manually entered. I want to be able to populate the first worksheet with that column data depending on the name and the corresponding data in the added column.

The names in the rows repeat multiple times, and every time the name repeats, it needs to have the same data that's in the column in the second worksheet. The number of repetitions is different between both worksheets.

I will have to search the first column in the second worksheet to see if the name matches to that of the first worksheet. I will then need to have the data in the next column returned to the first worksheet. (The return data can be placed in the column next to the names.)

Please see that attached file for an example of what I want. Sorry for the confusing explanation.

Thanks.