Originally Posted by michellep

I'm on Excel 2003, Windows XP. No VBA, please (beyond my and my co-worker's capabilities).

I have a MATCH function that is working successfully like this:
=IF(ISNUMBER(MATCH(A1,Sheet1!A:A,0)),"Yes","")

But what I'd like to know is the syntax required to query multiple sheets.
For example, I've tried:

=IF(ISNUMBER(MATCH(A1,Sheet1!,Sheet3!,Sheet4!A:A,0 )),"Yes","No")

AND

=IF(ISNUMBER(MATCH(A1,'Sheet1'!A:A,'Sheet3'!A:A,'S heet4'!A:A0)),"Yes","No")

Neither one work. Thus, my quest is: can MATCH be used to search several sheets? If not, please let me know (I've tried searching for an answer to this to no avail).

If so, how do I list the names of those worksheets?

Thank you!