Vlookup function help needed...

[LearnExcl]

Good morning Excel Gurus!

I have an updated name roster listed under on B1:B240 on Sheet1. I also have a database of names on B1:B240, C1:C240 and D1:D240 on Sheet2. I would like to crosscheck the database against the updated roster to see if there are any new personnel additions. In other words, I want to see if what I am showing matches with the updated roster. In this manner, I would like to construct a formula on C1 on Sheet2 to say:
If any of the names on B1:B240, C1:C240 and D1:D240 on Sheet2 have an exact match with the names appearing on B1:B240 on Sheet1, then give me that name, if not, give me nothing ("").

I have tried the countifs function, but had difficulty returning the names I wanted. Any help will be greatly appreciated.
<!-- / message -->

 

[Peter_SSs]

Duplicate to this thread.

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.