Worksheet name through lookup

[tminhv]

How can I reference a worksheet name from a cell found from a lookup function?

For example, xlookup searches within worksheet 1, 2, and 3 for value. If value is found in worksheet 3, I want it to return "C", if value is found in worksheet 2, I want it to return "B" and so forth.

 

[bebo021999]

You may need to return sheet name first, in cell, i.e, A1 (or any cell) by input this formula in A1:

=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1))+1,255)

Then point to this cell A1 to get the sheetname.
For example, search "Value" in range A1:Z100 for sheet1, sheet2,...

=IF(COUNTIF(Sheet1!A1:Z100,Value),Sheet1!A1,IF(COUNTIF(Sheet2!A1:Z100,Value),Sheet2!A1,...

 

[tminhv]

You may need to return sheet name first, in cell, i.e, A1 (or any cell) by input this formula in A1:

=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1))+1,255)

Then point to this cell A1 to get the sheetname.
For example, search "Value" in range A1:Z100 for sheet1, sheet2,...

=IF(COUNTIF(Sheet1!A1:Z100,Value),Sheet1!A1,IF(COUNTIF(Sheet2!A1:Z100,Value),Sheet2!A1,...

Unfortunately, cell formula doesn't work on 365.

 

[Fluff]

cell formula doesn't work on 365.

Yes it does, but it doesn't work with the online version.

 

[tminhv]

Is there a way to have it work with the online version? or a workaround?

 

[Fluff]

As you have given virtually no information, maybe

=IF(ISNUMBER(XMATCH(A2,Sheet1!A2:A100)),"A",IF(ISNUMBER(XMATCH(A2,Sheet2!A2:A100)),"B","C"))