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

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

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

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

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
.