Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Formual Error
Hi,
I am trying search a particular character in a cell and i used "Search" Function. Here is the formual I used but it is returning error. =IF(OR(SEARCH("ABC",A1),SEARCH("123",A1)),"Contain s","Does not contain") the requirement is to check 2 different characters in the cell. So I used OR function. Result A B ABC 123 Contains ABC #VALUE! 123 #VALUE! EL #VALUE! The second and third row should return the value as "contains" but it is returning error. Can anyone help me to fix this. Thanks in advance! Christ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IsError error on Search | Excel Discussion (Misc queries) | |||
WHAT DOES FORMUAL =C8+ 15 DO | Excel Discussion (Misc queries) | |||
Set Formual | Excel Discussion (Misc queries) | |||
Error handling in a search | Excel Discussion (Misc queries) | |||
The search key was not found error | New Users to Excel |