Microsoft Excel Question

Discussion in 'General Programming Chat' started by Entertainment, Aug 16, 2016.

  1. Entertainment

    Entertainment Junior Member

    Joined:
    Apr 23, 2012
    Messages:
    165
    Likes Received:
    17
    Hi Guys,

    I know this is probably the wrong section for my question, but it's as close as I could find. If you know which section I should post this in, please tell me & I will try to move the thread.

    Anyway...

    Does anyone know how I can automate this process in excel so I don't need to do it manually?

    Basically I have two spreadsheets. One with just names, and another with a larger set of names (including all the ones on spreadsheet 1) and their respective email addresses. How can I copy across the email addresses onto spreadsheet 1 for the names on spreadsheet 1?

    Thanks
     
  2. urobee

    urobee Junior Member

    Joined:
    May 1, 2016
    Messages:
    135
    Likes Received:
    28
    Do You think something like this?:

    put this code cell B1 on sheet1 then copy the code downward.
    =VLOOKUP(A1;Sheet2!A:B;2;FALSE)

    The code will work if:
    -on sheet1 the names are in column A
    -on sheet2 the names in column A and email adresses in column B.
     
    • Thanks Thanks x 2
  3. Entertainment

    Entertainment Junior Member

    Joined:
    Apr 23, 2012
    Messages:
    165
    Likes Received:
    17
    Just tried this, and there appeared to be an error in 'A1', going to be researching the VLOOKUP function though.
     
  4. stevie

    stevie Newbie

    Joined:
    Jul 31, 2010
    Messages:
    49
    Likes Received:
    10
    Location:
    UK
    Home Page:
    I stopped using VLOOKUP in favor of INDEX & MATCH, I find it a much better function.