INDEX MATCH based on two Field Conditions

I'm looking for some solution where INDEX MAtch find the output of my keyword based on a condition.
I'm having list of city names with change values in front for each city. In my second sheet i'm calling the value to give me value for City XYZ if the district is ABC.
Currently I'm using " =INDEX(Sheet1!$D$3:$D$13,MATCH(C3,Sheet1!$C$3:$C$13))"
But the problem is that it pick first come city value.

For Exacmple: In my BASE sheet I've Jordan three times under different Districts and each times its value is changed. When i call it from my data entry sheet it picks up the first value and do it again whenever the word "Jordan" comes whereas the value is change for another "JORDAN"

Attached Sheet might clear the idea further.


Excel issue.png

The Red Color shows incorrect values when compare to table 1 at left side

Try this

=INDEX(BASE!$D$4:$D$14,MATCH(1,(B3=BASE!$B$4:$B$14)*(C3=BASE!$C$4:$C$14),0))

or

=VLOOKUP(B3&C3,CHOOSE({1,2},BASE!$B$4:$B$14&BASE!$C$4:$C$14,BASE!$D$4:$D$14),2,0)

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

and also:

Please Login or Register  to view this content.

*edit: this is an array formula:
Confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Press F2 on that cell and try again.

Ben, you forgot to indicate that formula requires CSE