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

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
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

Sabeel's avatar
Sabeel
Copper Contributor
Dec 19, 2019
Thanks For Replay , its worked

Resources