Using wild characters for an array

[Guest]

I have the following array:

{=MAX(IF($H$3:$H$271="Lookup",$C$3:$C$271))} where it returns the max
value. Is there a way to use * to say if lookup is in the string then that
is an item to test the max on also. I was trying
{=MAX(IF($H$3:$H$271="*Lookup*",$C$3:$C$271))} but that does not work. Is
there a solution?

Thank you for your help.

Steven

 

[JE McGimpsey]

One way (array-entered):

=MAX(IF(ISNUMBER(SEARCH("Lookup",$H$3:$H$271)),$C$3:$C$271))

If you want the search to be case-sensitive, use FIND() instead of
SEARCH().

 

[Guest]

Right on the button. Thank you.

One way (array-entered):

=MAX(IF(ISNUMBER(SEARCH("Lookup",$H$3:$H$271)),$C$3:$C$271))

If you want the search to be case-sensitive, use FIND() instead of
SEARCH().