If function with text & wildcards

[Kpercy]

Sorry if this is a stupid q but I'm just not getting it...What's formula that
matches this description? I'm stuck on the "contains" or "starts with" for
evaluating text with an IF function... Also, if you can please email me at
(e-mail address removed), my passport acct always returns an error when I
follow an email link back to post.

If A4 contains "mobile broadband" return "data card" otherwise return "cell
phone".

Thanks, Katie

 

[francis]

try

=IF(A4="mobile broadband","data card","cell phone")

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis

 

[Kpercy]

Francis - that would work for EQUALS but I need it to be CONTAINS or STARTS
WITH. There's several diff entries that start with mobile broadband and I
want to include them all.

 

[Ashish Mathur]

Hi,

Try this:

=IF(ISNUMBER(FIND("mobile broadband",C16,1)),"Data card","cell phone")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com