Testing- Comparing two spreadsheets to validate the employee is in the database

Hi there,

I am new to the community so I apologize in advance if my question is unclear etc.

So I`ve been comparing many spreadsheets containing samples lately. The type of spreadsheets I compare, often change format/information but the master data spreadsheet I run it against remains constant. It gets very time consuming to look at a row and then opening the master data and searching for that person to verify their name is infact in the list.


I was hoping to automate the process, or atleast have a search bar where I can quickly type the name and have information show up. I initially started with an access database form to do the job, but I realized the spreadsheets change quite often and maintaining the database would be a hastle. I tried using vlookup but was not sure if it would suit my needs.

Any ideas or help would be appreciated. Maybe Ideas on how I can make it better or what process to adopt.
Thanks a lot,
imad.

So I tried using VBA to set up a search bar. But the code I found, does not work on my file. I`m not too familiar with coding so if anyone could easily detect the problem, I would be really grateful!

Thank you