Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Merging two columns from 2 Excel Sheets

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Chicago, USA
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could anyone help me in MERGING data from two colums into one.

    Eg:
    From Person A, I got sheet with Column A having Cities name; Column B Zip Codes

    From Person B, I got the same TYPE of information but data is different.

    I want to creat one Sheet which LISTS ALL information about ALL cities in column A and ALL Zipcodes in column B.

    Any help will be highly appreciated.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'day,

    You're likely looking at a VLOOKUP approach.

    Adam

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Chicago, USA
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you for your reply..

    Can you help me how to use VLookup..I never used it!

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    _________________
    If you can help a guy in trouble -
    If you can sort that nagging problem -
    Pease try, at home, at work or on a message board.

    Others help you!
    So PLEASE help if you can - If only the once.

    Thank you -

    Rdgs
    ======

    [ This Message was edited by: Jack in the UK on 2002-05-01 13:53 ]

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure thing,

    If one list of names represents a subset of the other then you can likely apply a vlookup for each column of missing data.

    Your Formulas will probably look like this:

    =VLOOKUP(A2,Sheet2!A2:E200,2,false)

    Where:
    A2 = a name (or row identifier) that your trying to find in the other sheet

    Sheet2!A2:E200 = the range your looking for the value in A2 (Column A on Sheet 2 should hold this value).

    2 (the 3rd argument) is a column index. Basically this indicates that when you find the value from A2 in the Sheet2 range, the formula will output the 2nd column next to that value (column b in this example).

    False = optional argument (you can also use 0). Indicates you want an exact match.

    Hope that helps,
    Adam

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Chicago, USA
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Adam:

    Thank you for explaining the formula.

    It works if I am fetching data from Sheet2 only; how about if I want to capture information from Sheet 2 and Sheet 3 for Column A on sheet 1.

    Any idea that can help me!!

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    a little confused,

    Are you writing this formula on a 3rd sheet or on one of the 2 existing ones?
    From your last post, it sounds like you're trying to pull column A data that should exist on either Sheet1 or sheet 2 - and you want the formula to pull from the correct sheet.

    To do this (and I admit I'm guessing what you want), you'd want to wrap an if statement around the formula. Something like:

    =IF(COUNTIF(Sheet2!$A$2:$E$200,B2)>0,VLOOKUP(B2,Sheet2!$A$2:$E$200,2,false),VLOOKUP(B2,Sheet3!$A$2:$E$200,2,false))

    Please msg back if I'm way out in left field.
    Adam


  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Chicago, USA
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Adam:

    THANK YOU for helping me. It works for me...

    Sorry for not being clear on my question..

    Best Reagrds,
    AAA

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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