Matching names in two different spreadsheets

[Hapdawg88]

I have two spreadsheets: one with hundreds of rows of certain data and the other with thousands of rows of other data. I would like to find the names of the people in the smaller spreadsheet in the larger one. Does anyone know how to do that? I have heard of VLOOKUP but have never used it. Nothing I read about it mentions finding the same value in both columns.

I would appreciate any insight anyone has. Thank you!

 

[Special-K99]

With names in Sheet1 column A and names to look at in Sheet2 column B

in Sheet1!B1
=IFERROR(VLOOKUP(A1,Sheet2!B$1:B$100000,1,0),"NOT FOUND","FOUND")
copy down column A

Adjust the formula to fit your data