Text comparison between multiple columns

Hello, folks

I am looking for some direction in comparing text value between multiples columns. Here is my issue: I have a list of students from a teacher, I also have a master list of all students for all schools with username and password. I would like to compare if the first name and last name are similar on both worksheets, then give me the firstname, lastname, username and password value of that student.

Your advice is greatly appreciated.

IF you create an extra column and place in it the concatentated fist name last name pairs (FirstName & " " & LastName), you could use VLOOKUP to find the matches as you are now only comparing one column.