Search / Find Function

Hello,

I have a list of 117 people whose names have been split into First Name and Last Names, and I need to search in 17 separate workbooks to see if any of these names are listed. Within the workbooks the names are listed in one cell as a Full Name next to the additional data, rather than separated out into First Name and Last Name.

I started off using the Find function which worked, but this will take far too long with all the spreadsheets and I am sure there must be a way of doing a multiple value search?

If you could help it would be most appreciated :)

Thanks

Natalie