Forum Discussion
Solved
Please Help to find the formula
Hi,
Try one of these formulas:
=IF(OR(ISNUMBER(MATCH(F3,$A$3:$A$9,0)),
ISNUMBER(MATCH(G3,$B$3:$B$9,0)),
ISNUMBER(MATCH(H3,$C$3:$C$9,0))),"done","")=IF(SUMPRODUCT(--(F3:H3=$A$3:$C$9)),"done","")
Hope that helps
As a comment - Twifoo formulas works, as Detlef_Lewin says you only shall change curve quote on straight quote. That could be misprint, but one to another is often changed when you copy/paste from Web or back.
Thanks For Replay