Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ISNA(MATCH...) and IF functions - can they be combined?
I want to check whether a value in one spreadsheet (call it spreadsheet A)
exists in up to 3 other spreadsheets (call them spreadsheets B, C & D all of which exist in independent workbooks). What I want it to do is: 1. check whether the value exists in s/s B, 2. if so make the value of the cell where my search formula is "FALSE", 3. if the value isn't found in s/s B then check for it in s/s C, 4. if it is found there make the value of the cell where by formula is "FALSE", 5. if the value isn't found in s/s C either then check s/s D 6. again returning the value "FALSE" if it is found there. So if the value is found in any of the 3 external spreadsheets the value in my search cell will be "FALSE", if my search value is not found in any of the spreadsheets the cell value will be "TRUE". I can easily check for it in one other worksheet using the =ISNA(MATCH...) function but I can't seem to work out how to check more than 1 other worksheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IsNA(match | Excel Worksheet Functions | |||
IsNA(match | Excel Worksheet Functions |