Index- match not working

问题:

For the following table how do I Retreive Column C if both Column A and Column B matches

Column A       Column B      Column C
City 1              City 10          Local
City 2              City 21          Remote
City 3              City 1            Remote
City 4              City 2            Local

I tried using index and match but am getting #N/A

回答1:

Enter as an array formula with Ctrl + Shift + Enter

=INDEX(C1:C4,MATCH(D2&E2,A1:A4&B1:B4,0),0)