Search locality in address

I have a file contains Sets of more than 200 rows of locality in column A & its Area codes in column B

Column D has more than 5000 Adresses. I want to find localities in that addresses if any of the locality From column A Matches then It will comes column E of that row (Matched Locality) along with its code in Column E.


A sample file is attached below Plz help !!!!!!!!!

Hi,
Try below formula

=VLOOKUP(E1,$A$1:$B$10,2,)

OR

=INDEX($B$1:$B$10,MATCH(E1,$A$1:$A$10,0))

Hi,

I want to search locality in address also

Hi,
in G2 Cell, Put the below formula
=INDEX($D$2:$D$13,MATCH(E2,$A$2:$A$10,0))

Hi,
plz find attachment