Vlookup - getting answer from month upon month data

I have created a table with a drop down option to see a salespersons performance at any given month in the year.

I have one rating cell, which changes month on month, with it being either "poor", "good" or "excellent".

So I have data from Jan24 to Dec24, with sales persons names, and their rating month on month.

Would anyone know how I would do a look up to pull through what the monthly rating is for any given salesperson? For Ex, I want to see Dave Smith's rating in Jan-24, and then see what it is like in Aug-24.

EDIT: AS per example below, I want (on another tab) to be able to look up the employee, and what their rating was in a particular month

Well, put some data together as you only gave an image.

Used index() with match(), check out the match as it is using two columns.

Data validation is used in E3 and F3 to select the month and employee.

Then if you need to find duplicates as well, consider something like this: https://stackoverflow.com/a/58640367/4961700