Can the MATCH function search across several worksheets?
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! |
Quote:
|
All times are GMT +1. The time now is 06:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com