| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
isnumber search
Hi,
Can you please help? Trying to look for words in a cell if it contains "FHA" then give me FHA. If it contains "VA" then give me VA. If it contains "Streamline" then give me Streamiline. Anything else give me Conv. I am trying this: =IF(ISNUMBER(SEARCH("FHA",E6)),"FHA") but I can't seem to string the next If statements together properly. Thanks, Scot |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isnumber search
On Thu, 20 May 2010 14:33:01 -0700, scottay
wrote: Hi, Can you please help? Trying to look for words in a cell if it contains "FHA" then give me FHA. If it contains "VA" then give me VA. If it contains "Streamline" then give me Streamiline. Anything else give me Conv. I am trying this: =IF(ISNUMBER(SEARCH("FHA",E6)),"FHA") but I can't seem to string the next If statements together properly. Thanks, Scot Try this formula: =INDEX({"FHA","VA","Streamiline","Conv"},MATCH(TRU E,ISNUMBER(SEARCH({"FHA","VA","Streamline",""},E6) ),0)) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isnumber search
How about:
=IF(ISNUMBER(SEARCH("FHA",E6)),"FHA",IF(ISNUMBER(S EARCH("VA",E6)),"VA",IF(ISNUMBER(SEARCH("streamlin e",E6)),"streamline","conv"))) -- Gary''s Student - gsnu201003 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isnumber search
Perfect! Much appreciated.
"Gary''s Student" wrote: How about: =IF(ISNUMBER(SEARCH("FHA",E6)),"FHA",IF(ISNUMBER(S EARCH("VA",E6)),"VA",IF(ISNUMBER(SEARCH("streamlin e",E6)),"streamline","conv"))) -- Gary''s Student - gsnu201003 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
isnumber search
Works great.
Thanks! "Lars-Ã…ke Aspelin" wrote: On Thu, 20 May 2010 14:33:01 -0700, scottay wrote: Hi, Can you please help? Trying to look for words in a cell if it contains "FHA" then give me FHA. If it contains "VA" then give me VA. If it contains "Streamline" then give me Streamiline. Anything else give me Conv. I am trying this: =IF(ISNUMBER(SEARCH("FHA",E6)),"FHA") but I can't seem to string the next If statements together properly. Thanks, Scot Try this formula: =INDEX({"FHA","VA","Streamiline","Conv"},MATCH(TRU E,ISNUMBER(SEARCH({"FHA","VA","Streamline",""},E6) ),0)) Hope this helps / Lars-Ã…ke . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine: ISNUMBER(SEARCH( and EXACT( ? | Excel Discussion (Misc queries) | |||
| =IF(ISNUMBER(SEARCH("ELB", and more than one text | Excel Worksheet Functions | |||
| ISNUMBER & SEARCH problem | Excel Discussion (Misc queries) | |||
| SUMPRODUCT + ISNUMBER(SEARCH) + Empty Cells | Excel Discussion (Misc queries) | |||
| Limit to nested IF(ISNUMBER(SEARCH)) functions? | Excel Worksheet Functions | |||
Linear Mode
