Is Like Lookup

[Susana]

Hi,

Is there an is like lookup function?

I am trying to look in column A for any items that have an HM, where column a
contains 1234HM, 12572, 24751BP, etc. and return in column B "yes" if there
is an HM....

@if(A1 is like "HM", "yes","no")

Thanks for any help!

 

[Chris]

If you use the =FIND() function this should do the trick.

You may also want to use the =ISERROR() function to clean up the output
as FIND give's a #VALUE! output if it can't find what it is looking
for.

There's probably a way of doing it in one . . . .

 

[Ron Rosenfeld]

Hi,

Is there an is like lookup function?

I am trying to look in column A for any items that have an HM, where column a
contains 1234HM, 12572, 24751BP, etc. and return in column B "yes" if there
is an HM....

@if(A1 is like "HM", "yes","no")

Thanks for any help!

Case Insensitive:

=IF(COUNTIF(A1,"*HM*"),"Yes","No")

Case Sensitive:

=IF(ISNUMBER(FIND("HM",A1)),"Yes","No")


--ron

 

[RagDyeR]

Try this:

=IF(ISNUMBER(SEARCH("HM",A1)),"YES","NO")


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi,

Is there an is like lookup function?

I am trying to look in column A for any items that have an HM, where column
a
contains 1234HM, 12572, 24751BP, etc. and return in column B "yes" if there
is an HM....

@if(A1 is like "HM", "yes","no")

Thanks for any help!