I am having 2 worksheet and each of them having name of student.Sheet1 has student name and roll number,sheet2 has name only.

I want to match sheet1 student name with sheet2 student name.Names in both the sheets are not exactly matching.I want to match names on the basis of first name(first word) and last name (last word) or firstname or last name.For example

Sheet1 Name = Nirmali Steve Joe , Sheet1 Roll No= 1572
Sheet2 Name - Nirmali Joe

I should get result Nirmali Joe, 1572

I appreciate your help