Using wild characters for an array
 

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

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().


In article ,
Steven wrote:

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

Right on the button. Thank you.

"JE McGimpsey" wrote:

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().


In article ,
Steven wrote:

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