I'm not sure if this is possible of if it's just that I can't seem to wrap my brain around what is wrong with the way I'm trying to write a formula.
1. =IF(OR(F2=D2,F2=E2),"APPLE"," ") - works fine
2. =IF(OR(G2=D2,G2=E2),"ORANGE","") - works fine

Is it possible to combine the two? Right now Column H has formula 1 and Column I has formula 2 but ideally if I could just put a formula in Column H that would give me results of either 1 or 2, that would be great.

- Wheelie686