If function -

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I use a 'LIKE' operator rather than the '=' one?
For instance:
=If(A1 LIKE "Ford", this,that)
If not, is there an alternative which will return partial matches?
 
perhaps ..

=IF(ISNUMBER(FIND("Ford",A1)),"found","not found")

FIND is case sensitive, SEARCH is not.

=IF(ISNUMBER(SEARCH("Ford",A1)),"found","not found")

HTH
 
u can use text formula Exact() or Find()
=if(exact(a1,food),this,that)
or
=if(iserror(find(food,a1),that,this)

hope this can be helpful
 
Thanks very much
--
tia

Jock


Toppers said:
perhaps ..

=IF(ISNUMBER(FIND("Ford",A1)),"found","not found")

FIND is case sensitive, SEARCH is not.

=IF(ISNUMBER(SEARCH("Ford",A1)),"found","not found")

HTH
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup / Summary Table 8
With F1 value, look at A, if match or partial match return B 5
Access Remove rows based on multiple fields 2
Frank, Sumproduct, it works but I am confused 7
VLOOKUP & SUMIF 6
Find partial text and retrun value in corresponding column 3
Using Index Match etc. for price list 4
IF formula, Partial word, SUM function as result 1

Back
Top