Hi,

I am able to return the numerical value in cell G12, if the cell AZ12 has the text "apple" with the formula below. If apple isn't in that cell, it will be 0.
=IFERROR(FIND("APPLE",AZ12)*G12,0)

I want to also return the value in G12 if AZ12 says either "apple", "orange", "banana" etc, but am struggling to do so.
I have tried:
=IFERROR(FIND("APPLE",AZ11)*G12,0)*OR(FIND("ORANGE",AZ11)*G12,0)*OR(FIND("BANANA",AZ12)*G12,0)

Trying to extend this beyond one value returns IF ERROR value.

Anyone able to help me out?

Thank you,
Kanuck