Lookup with duplicate values & AND Condition

Kindly help me in finding the correct city by formula in the attached excel sheet.

Thank you.

=INDEX($C$2:$C$21,MATCH($E$3&$E$7,$A$2:$A$21&$B$2:$B$21,0))

Array entered for first occurence of city for the selected

=LOOKUP(2,1/($A$2:$A$21=$E$3)*($B$2:$B$21=$E$7),$C$2:$C$21)

For last occurence(newest).
As you did not mention the expected results use either one and if it not ok, then, provide expected results.

Thanks paul..first formula is what i wanted..

in 2nd one, the result is the city of the last occurrence of the first name & does not considers the last name.

Apologies for that. Change the second formula to:

=LOOKUP(2,1/($E$3=$A$2:$A$21)/($E$7=$B$2:$B$21),($C$2:$C$21))

thanks paul..the 2nd one also works well now..