in worksheet2 add an extra column that concatenates surname and name, and do the same in sheet1.

then use offset and match to find a match in sheet2 and return yes or no as appropriate

=offset(reference cell,match(cellwithconcatnameinsheet1,myrange,0),4)

myrange is the column in sheet2 with concatnames
4 is the horizontal offset (+ for right, minus for left)