index match array formula with and or logic.

Try:

Formula:

Please Login or Register  to view this content.

PS. Strange that you want to compare both E2 and G2 with D column (if E2<>G2 then you never get result. If E2=G2 no point to use anythuing else than original formulas).
Is that the case? if yes, then I probably misunderstood what you want to achieve.

=INDEX('Price list'!$F$1:$F$31506,
MATCH(1,(B2='Price list'!$B$1:$B$31506)* (E2='Price list'!$D$1:$D$31506) + (B2='Price list'!$B$1:$B$31506) * (G2='Price list'!$D$1:$D$31506),0))

Well ... in this sense "and-or" logic. OK, then my version is:

Formula:

Please Login or Register  to view this content.

the previous was "and-and" one :-D