Return all sheet names if value actually exists in the workbook

[Eduards]

Hi,

I have values inside column A (Sheet1). Inside column B and rest of the row, I need a formula that searches that specific value from column A, inside all sheets (Column A for all sheets) and returns the sheet name if that value is existing inside that specific sheet. If its multiple sheets, then continue down the row and return the name of the sheet name.

Any more detail let me know.. Thanks

[Bo_Ry]

Is this work?

B11 drag to C11 and drag down
IF(COUNTIF(INDIRECT("sheet"&COLUMNS($A11:B11)&"!A:A"),$A11),"Sheet"&COLUMNS($A11:B11),"")

or
B11
=IF(COUNTIF(Sheet2!A:A,A11),"Sheet2","")
C11
=IF(COUNTIF(Sheet3!A:A,A11),"Sheet3","")

[Eduards]

Thats perfect! I have used the top formula