Show worksheet name on match found

Hi,

I need to show the name of the worksheet where the cell match is found. Can you please help me out with the formulas?

Thank you so much.

Put this formula in C3:

=IF(ISNUMBER(MATCH(D3,'Shop A'!A:A,0)),"Shop A",IF(ISNUMBER(MATCH(D3,'Shop B'!A:A,0)),"Shop B",IF(ISNUMBER(MATCH(D3,'Shop C'!A:A,0)),"Shop C","not found")))

then copy down.

Hope this helps.

Pete

Awesome, it works great. Thank you for such quick response.