Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can the MATCH function search across several worksheets? | Excel Worksheet Functions | |||
vlookup or match function across worksheets ? | Excel Discussion (Misc queries) | |||
MATCH function through multiple worksheets | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) |