Excel Doubt

Discussion in 'Programming' started by krkbkk, Feb 10, 2013.

  1. #1
    I've an excel file where Column A got addresses.

    Column D got list of Cities.

    I need a formula to look at the Column A against Column D and if the any one of the cities listed in Column D is present in Column A, it has to return the City name in Column B.

    How to do this? Any idea?

    Thanks in advance.
     
    krkbkk, Feb 10, 2013 IP
  2. ds28

    ds28 Greenhorn

    Messages:
    34
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    6
    #2
    try excel inbuilt functions like vlookup()
     
    ds28, Feb 12, 2013 IP
  3. zhy

    zhy Active Member

    Messages:
    55
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    71
    #3
    Yea, I usually use vlookup() function for that kind of task.
    But, to make it clear, can you give a sample (one or two row) of the data? So I can figure it out.
     
    zhy, Feb 13, 2013 IP
  4. abcpune

    abcpune Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #4
    yes. vlookup() will help you solving this problem.
     
    abcpune, Feb 14, 2013 IP