Hi,
Try below formula
=VLOOKUP(E1,$A$1:$B$10,2,)
OR
=INDEX($B$1:$B$10,MATCH(E1,$A$1:$A$10,0))
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
Bookmarks