1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    128
    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.