Hi,

I am trying to make a array formula that can pull info in one cell off of another sheet based on two cells values or two other cells values.

=INDEX('Price list'!$F$1:$F$31506,
 MATCH(1,(B2='Price list'!$B$1:$B$31506)*(E2='Price list'!$D$1:$D$31506),0))
this works fine but I need one that can also do,

=INDEX('Price list'!$F$1:$F$31506,
 MATCH(1,(B2='Price list'!$B$1:$B$31506)*(G2='Price list'!$D$1:$D$31506),0))
I would like them to be in the same code but cant figure out how to get it. any help would be appreciated.