MAX IF partial text met using multiple data columns

I've scoured everywhere for this and can only find solutions that use multiple criteria columns and not multiple data columns.

In the example I essentially want the maximum value (minimum as well but this will hopefully sort that out) of 3 columns of data everytime the letter C is in that row

Formulas used are

{=MAX(IF(A2:A9388=G2,B2:C9388))} - works for exact match
{=MAX(IF(A2:A9388=H2&"*",B2:C9388))} - doesn't work for partial match

Is the reason it doesn't work because it's an array? Should I try avoid arrays?

Or try:

=MAX(IF(LEFT(A2:A9388,LEN(H2))=H2,B2:C9388))

Try

=MIN(IF((ISNUMBER(FIND("C",UPPER($A$2:$A$93)))*($B$2:$B$93<>0)),$B$2:$C$93))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Thanks for the reply, the formula works like the others but still finds 0 as the lowest number. I can't get it to ignore all 0's

Post a file as it worked for me.

See attached:

I'm an idiot! That worked

Thank you!!