EXCEL - IF(IFERROR(VLOOKUP question

[Buddy18]

Looking for some guidance. I have the following formula: =IF(IFERROR(VLOOKUP([@Name],sheet1!A:A,1,FALSE),"No")="No","No","Yes")

I need the formula modified to execute the same for 3 sheets within my excel file (sheet1, sheet2, sheet3)

My experience with formulas are a bit limited. Any examples to get the required about would be greatly appreciated!

Thanks!