Excel Formula - IF statement issues

[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)

Note: If this needs a different excel function, please provide a suggestion.

Thanks everyone!

 

[shift-del]

Hi Buddy18

=IF(COUNTIFS(Sheet1!A:A,[@Name])+COUNTIFS(Sheet2!A:A,[@Name])+COUNTIFS(Sheet3!A:A,[@Name]),"YES","NO")

 

[Buddy18]

Hi Buddy18

=IF(COUNTIFS(Sheet1!A:A,[@Name])+COUNTIFS(Sheet2!A:A,[@Name])+COUNTIFS(Sheet3!A:A,[@Name]),"YES","NO")

Thanks for your fast response and perfect solution, it worked! I truly appreciate it.

 

[shift-del]

You're welcome.