If your names are in colums and set up like A1 of sheet one and A1 of sheet 2 you can use something like this to compair columns and rows, but if they are not lined up and scattered all over the sheet it will not work.
This assumes that sheet 1 name will always have SHRI. before the name and looks at the 6th char and compairs 5 chars to sheet 2 to return a 1, for true and a 0 for false. you can change the 1 & the 0 to what ever you want.
Now if you dont want to create a third sheet and are looking for more of a way to highlight duplicate names you might look into conditional formatting.
If you can upload an example of your sheet.