Search name MATCH duplicates across sheets

Hello,

I'm a basic user of excel and really struggling to grasp some of the tutorials on matching cells across sheets in excel.

I am coordinating volunteers for an event and they all have to complete an online induction - I then have to download an excel report of who has completed the induction and compare this with my list of volunteers which are imbedded over multiple sheets in the workbook.

What I would like to do (if it is possible) is set a formula so that I paste the list of the names who have completed the induction and where that name matches with a name in the workbook, a YES appears next to their name in an adjacent cell.

Is this possible and if so what is the formula?

Any advice/tips is greatly welcome!

Many thanks,
Jaye

What columns will the names on the worksheets be to check against? Can you upload a sample workbook?

Maybe something like this? This formula assumes that the names on the worksheets are in column A, and that when you load the names they will start from cell A1. And the sheets are names Sheet1, Sheet2, etc. This show you up to three sheets, but you can add more iferror and match functions until you get however many sheets you have.

Formula:

=IF(ISNUMBER(IFERROR(MATCH(A1,'Sheet1'!A:A,0),IFERROR(MATCH(A1,'Sheet2'!A:A,0),MATCH(A1,'Sheet3'!A:A,0)))),"YES","")