| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for same Names in cells
works fine
Thanks guys "Vergel Adriano" wrote in message ... You're right, Rick. I think I first had it say Found/Not Found then changed it to True/False but didn't realize I no longer needed the IF function. For the OP, you'll only need the IF function call if you want it to say something other than True/False in the cell. =IF(ISNUMBER(SEARCH(A2,K2,1)), "Found", "Not Found") -- Hope that helps. Vergel Adriano "Rick Rothstein (MVP - VB)" wrote: try this formula in L2: =IF(ISNUMBER(SEARCH(A2,K2,1)), TRUE, FALSE) It will return TRUE if value in A2 is found in K2. Since ISNUMBER returns TRUE or FALSE directly, you don't really need the IF function call to repeat those results. This works exactly the same.... =ISNUMBER(SEARCH(A2,K2,1)) Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
| Can I check names in one list agains names in another in excel? | Excel Discussion (Misc queries) | |||
| Check Box names | Excel Programming | |||
| Referencing check box names in VBE | Excel Programming | |||
| range names or check box | Excel Worksheet Functions | |||
![DaveM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
