Match formula

[eganeyar]

Hello Everyone,

May I request for your assistance to create a formula for Column C (Delivery Status) to match Column E.

Country	Fruits	Delivery Status		Delivery Status	Country	Fruit
England	Apple	Yes		Yes	England	Mango
US	Orange	No		Yes	US	Apple
				No	Japan	Orange
				No	US	Orange
				Yes	England	Apple
				Yes	Japan	Mango

<tbody>
</tbody>

 

[Canapone]

Hi

a possible approach:

=IFERROR(INDEX(E$1:E$7,MATCH(A2&B2,INDEX(F$1:F$7&G$1:G$7,),0)),"")

Regards

 

[eganeyar]

many thanks!

 

[Dim Me as xlNoob]

Hi

a possible approach:

=IFERROR(INDEX(E$1:E$7,MATCH(A2&B2,INDEX(F$1:F$7&G$1:G$7,),0)),"")

Regards

Very cool! I didn't know you could MATCH like that! I came up with this:

=IFERROR(LOOKUP(1,1/(($F$2:$F$7=A2)*($G$2:$G$7=B2)),$E$2:$E$7), "NO MATCH")