Results 1 to 5 of 5

Thread: Search locality in address

  1. #1

    Search locality in address



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 !!!!!!!!!
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    Try below formula

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

    OR

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

  3. #3
    Hi,

    I want to search locality in address also

  4. #4
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    in G2 Cell, Put the below formula
    =INDEX($D$2:$D$13,MATCH(E2,$A$2:$A$10,0))

  5. #5
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz find attachment
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •