| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Forumla Help Please! What am I doing wrong?
=IF(ISNA(MATCH(B1,Sheet1:Sheet2!B:B)),"No Match","Match")
This formula searches to see if (X) is on sheet 1 or sheet 2. I need it too search sheet1 and sheet2 too see if it is on both. Anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Forumla Help Please! What am I doing wrong?
=IF(OR(ISNA(MATCH(B1,Sheet1!B:B)), ISNA(MATCH(B1,Sheet2!B:B))),"No
Match","Match") -- HTH... Jim Thomlinson "Dan C." wrote: =IF(ISNA(MATCH(B1,Sheet1:Sheet2!B:B)),"No Match","Match") This formula searches to see if (X) is on sheet 1 or sheet 2. I need it too search sheet1 and sheet2 too see if it is on both. Anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Forumla Help Please! What am I doing wrong?
=IF(ISNA(MATCH(B17,Sheet1!A:A,0)),"not on 1","on 1")&"
"&IF(ISNA(MATCH(B17,Sheet2!A:A,0)),"not on 2","on 2") -- Don Guillett Microsoft MVP Excel SalesAid Software "Dan C." wrote in message ... =IF(ISNA(MATCH(B1,Sheet1:Sheet2!B:B)),"No Match","Match") This formula searches to see if (X) is on sheet 1 or sheet 2. I need it too search sheet1 and sheet2 too see if it is on both. Anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an Excel forumla to count different coloured cells? | Excel Discussion (Misc queries) | |||
| Excel Forumla (vlookup problem) | Excel Discussion (Misc queries) | |||
| Which Forumla and How do I configure in Excel? | Excel Discussion (Misc queries) | |||
| Need to Escape from Excel Forumla Hell! | Excel Worksheet Functions | |||
| Excel Forumla to seach and return all values | Excel Worksheet Functions | |||
![Dan C.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
