need slight edit to ISNUMBER)MATCH formula

[tlacloche]

please see the attached file.

the formula is working great apart from one thing...
when "rival fruit" is displayed between "SUNSHINE" and any of the fruits mentioned in the fomula (in this case "Orange", the result should not be "Profit".

so in the example in the attached file, i need cell T9 to not say "Profit"

thanks

[tlacloche]

can anyone help with this please

[XOR LX]

Hi,

I think you'd need to provide a bit more information about how you arrive at your expected results, and indeed what we should be trying to do.

Regards

[tlacloche]

when SUNSHINE is mentioned in column J, I would like the formula to recognise the nearest preceding fruit name (of any listed in the formula e.g. Orange, Apple, Banana)....

...BUT the formula can only give a "Profit" when "Our Fruit" is listed in column V on the same row as the fruit in column J.

this all works fine.
but i realised i need to add something to the formula

I want it to give "Profit" when all the rows from SUNSHINE to the chosen fruit are listed as "Our Fruit" in column V.
So in the example attached, make T9 not display "Profit" because cell V10 shows "Rival Fruit". remember cells V11 to V9 should all be "Our Fruit" for a "Profit" result

Thank you

[tlacloche]

can someone please help me. Im really really stuck on this.
thank you

[tlacloche]

can someone please help with this