Forum Discussion

shilpa288's avatar
shilpa288
Copper Contributor
Aug 08, 2019

Help with excel formulas

Hi,  I have attached 3 sheets in word doc . I have very simple one conditions that goes in main sheet column D8 1. =IF(AND(Sheet2!$E$2:$E$10000<=0.01,Sheet1!$E$2:$E$10000>=0.01),1,0)   Issues I a...
Excel 365
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 08, 2019

shilpa288 

Perhaps

=IFERROR(
    (INDEX(Sheet1!$E:$E,MATCH(1,INDEX((Sheet1!$A:$A=$B8)*(Sheet1!C:C=D$5)*(Sheet1!$B:$B=$C8),0),0))>=0.01)*
    (INDEX(Sheet2!$E:$E,MATCH(1,INDEX((Sheet2!$A:$A=$B8)*(Sheet2!C:C=D$5)*(Sheet2!$B:$B=$C8),0),0))<=0.01),
 "no such")

 

  • shilpa288's avatar
    shilpa288
    Copper Contributor
    Aug 20, 2019

    SergeiBaklan 

    Thank You. It worked for me.

    Sorry for late reply.

Resources