Match formula

[eganeyar]

Hello Everyone,

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]Fruits[/TD]
[TD]Delivery Status[/TD]
[TD][/TD]
[TD]Delivery Status[/TD]
[TD]Country[/TD]
[TD]Fruit[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD]Apple[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]England[/TD]
[TD]Mango[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]US[/TD]
[TD]Orange[/TD]
[TD]No[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]US[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]No[/TD]
[TD]Japan[/TD]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]No[/TD]
[TD]US[/TD]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]England[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]Japan[/TD]
[TD]Mango[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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")