Re-reading your first post ...

I need to search through sheet 1 and see if that persons data is on sheet 2

Regards