Hello,
The following array formula works perfectly:
Formula:
=IF(AND(ISNUMBER(MATCH(I2,{"Apple","Banana","Orange"},0)),MATCH("Happy",$I3:$I$240000,0)<MIN(IFERROR(MATCH({"Apple","Banana","Orange"},$I3:$I$240000,0),10^10))),IF(MATCH("Happy",$I3:$I$240000,0)>MIN(IFERROR(MATCH({"Expensive"},$AB3:$AB$240000,0),10^10)),"No Bingo","Yes Bingo"))
however, after the last row where the condition takes place, it just gives N/A errors from then on.
what can i do to the formula to give a blank cell instead of the N/A error? but everything else works the same.
also, "no bingo" is never displayed anyway. a FALSE is there instead. was wondering why this is. is there any need of it being in the formula above?
thank you.
Bookmarks