Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF question
I am attempting an IF lookup for a list of cells that have letters in them. I
know how to say IF the cell equals (=) a certain letter, but is there a way to say IF the cell contains a certain letter? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF question
=if(isnumber(search("a",a1)),"A1 contains an a","nope")
If you want to match case, then use =Find() instead of =search() And another way if you don't care about upper/lower case: =if(countif(a1,"*a*")0,"yep","nope") Alyssa wrote: I am attempting an IF lookup for a list of cells that have letters in them. I know how to say IF the cell equals (=) a certain letter, but is there a way to say IF the cell contains a certain letter? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF question
You'll want to use either FIND (case-sensitive) or SEARCH(non-case-sensitive)
For instance, if A1 = "This is a test" and A2 = "is" =IF(ISNUMBER(SEARCH(A2,A1)),"Text found","Not found" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Alyssa" wrote: I am attempting an IF lookup for a list of cells that have letters in them. I know how to say IF the cell equals (=) a certain letter, but is there a way to say IF the cell contains a certain letter? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
If then question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
VBA Question | Excel Discussion (Misc queries) |