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...
=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")
