Forum Discussion

Sabeel's avatar
Sabeel
Copper Contributor
Dec 18, 2019
Solved

Please Help to find the formula

 
excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Dec 18, 2019

    Sabeel

     

    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

NobukoIT's avatar
NobukoIT
Copper Contributor
Dec 18, 2019

Sabeel 

What about this method?

H9=IF(COUNTIFS($A$7:$C$13,$E9)+COUNTIFS($A$7:$C$13,$F9)+COUNTIFS($A$7:$C$13,$G9)>0,"done","not done")
H10=IF(COUNTIFS($A$7:$C$13,$E10)+COUNTIFS($A$7:$C$13,$F10)+COUNTIFS($A$7:$C$13,$G10)>0,"done","not done")
H11=IF(COUNTIFS($A$7:$C$13,$E11)+COUNTIFS($A$7:$C$13,$F11)+COUNTIFS($A$7:$C$13,$G11)>0,"done","not done")
H12=IF(COUNTIFS($A$7:$C$13,$E12)+COUNTIFS($A$7:$C$13,$F12)+COUNTIFS($A$7:$C$13,$G12)>0,"done","not done")

 

 

 

Resources