IFERROR + FIND multiple matches

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

Try

=IFERROR(IF(MATCH(AZ12,{"Apple","Orange","Banana"},0),G12,0),"")

entered with Ctrl+Shift+Enter

NAILED IT! It works perfect, thank you so much!
It works with or without the array, was there a reason I'd use the array specifically?
Thank you again!

I believe the following should also work based on what you were trying to do.

=IFERROR(OR(FIND("apple",AZ12),FIND("orange",AZ12),FIND("banana",AZ12))*G12,0)

You were on the right path. You just had too many OR functions and too many multiplication steps.

hey mfreem02, that one did not actually -- I gave it a go to test it out but it will return the IF ERROR value. I think I may have had that in one of my attempts before coming to all of you as well though

That worked as well Tony, thank you!