Not sure what to do, basic excel user

[donkx]

Data is simplified and/or removed for privacy. I'm attempting to extract data from our training records and compile the info into spreadsheets so that I can track who needs certain courses.
First screenshot shows basic layout of sheets/books. Second screenshot is how the data is extracted.
What I'm trying to do, is that if A1 in book 1, matches any cell in A in book 2, then I need it to return a YES in a specific column in book 1.
Ideally, I'd like to be able to delete book 2 when I'm done, if possible.
Thanks!

 

[awoohaw]

is the second image a workbook or a worksheet in the same workbook that the first image is in?
if in the same workbook then, and assuming sheet name of second sheet is sheet2 then:

=IF(ISNA(Match(A2,Sheet2!$A$2:$A$200,0)),"No","Yes")

if in a different workbook you need to reference the workbook name in front of the sheet name. AND, the workbook must be open.

=IF(ISNA(MATCH(A2,[OtherWorkbookName.xlsm]Sheet2!$A$2:$A$200,0)),"No","Yes")

I am assuming 200 rows in the lookup data. You need to change as needed.

 

[donkx]

Thank you!

is the second image a workbook or a worksheet in the same workbook that the first image is in?
if in the same workbook then, and assuming sheet name of second sheet is sheet2 then:

=IF(ISNA(Match(A2,Sheet2!$A$2:$A$200,0)),"No","Yes")

if in a different workbook you need to reference the workbook name in front of the sheet name. AND, the workbook must be open.

=IF(ISNA(MATCH(A2,[OtherWorkbookName.xlsm]Sheet2!$A$2:$A$200,0)),"No","Yes")

I am assuming 200 rows in the lookup data. You need to change as needed.

Thank you!!!

 

[awoohaw]

My pleasure. And welcome to the forum.

Thanks for the feedback.
Best wishes!