i have the formula which checks 5 criteria and 2 formula check the other 2 column which i put by (ctrl+shift+del) can we combine both the formula
1. formula
=MIN(MAX(G3*INDEX($S$3:$S$138,L3)%,E3+INDEX($X$3:$X$138,L3)),MAX(G3*INDEX($T$3:$T$138,L3)%,E3+INDEX($Y$3:$Y$138,L3)),MAX(G3*INDEX($U$3:$U$138,L3)%,E3+INDEX($Z$3:$Z$138,L3)),MAX(G3*INDEX($V$3:$V$138,L3)%,E3+INDEX($AA$3:$AA$138,L3)),MAX(G3*INDEX($W$3:$W$138,L3)%,E3+INDEX($AB$3:$AB$138,L3)))
2.formula- array ctrl+shift+del
=MATCH(1,($Q$3:$Q$138=A3)*($R$3:$R$138=B3),0)
1. formula
=MIN(MAX(G3*INDEX($S$3:$S$138,L3)%,E3+INDEX($X$3:$X$138,L3)),MAX(G3*INDEX($T$3:$T$138,L3)%,E3+INDEX($Y$3:$Y$138,L3)),MAX(G3*INDEX($U$3:$U$138,L3)%,E3+INDEX($Z$3:$Z$138,L3)),MAX(G3*INDEX($V$3:$V$138,L3)%,E3+INDEX($AA$3:$AA$138,L3)),MAX(G3*INDEX($W$3:$W$138,L3)%,E3+INDEX($AB$3:$AB$138,L3)))
2.formula- array ctrl+shift+del
=MATCH(1,($Q$3:$Q$138=A3)*($R$3:$R$138=B3),0)