Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Take data from two columns and match to another...

  1. #1
    New Member
    Join Date
    Jun 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Take data from two columns and match to another...

    Hello all,

    I'm struggling a bit on this one... Here is my conundrum:

    I have data in column A that matches C. I need the order of column A to remain untouched. Column C matches data of column D.

    I need the data from column D to match A (which is the same a C but in a different order).

    How can I get the data in column D to match column A with out finding each one and pasting the result one by one? I want to past the data in D in column B to match A (but from the C+D match).

    This is confusing, I know...

  2. #2
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    12,701
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Take data from two columns and match to another...

    Not sure i understand what you are looking for.

    See if this does what you need (if not, try to show us an example)


    A
    B
    C
    D
    1
    Header
    Result
    Header
    Header
    2
    A
    20
    C
    10
    3
    B
    30
    A
    20
    4
    C
    10
    B
    30
    5
    D
    50
    E
    40
    6
    E
    40
    D
    50


    Formula in B2 copied down
    =INDEX($D$2:$D$6,MATCH(A2,$C$2:$C$6,0))

  3. #3
    New Member
    Join Date
    Jun 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Take data from two columns and match to another...

    Thank you for quick reply! I tried it and received the error #N/A.

    Here is what I'm trying to do:



    So column A needs to stay in that specific order. The data from column A is the same as column C. I need the data from column D (that correlates with column C), to match A (in the end) in that specific order.

    My apologies, it's very confusing and might be too hard to explain. Hopefully it makes a little more sense.

    I appreciate any and all help!

  4. #4
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    12,701
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Take data from two columns and match to another...

    If all the values in col A are also present in Col C the formula i suggested above should work - provided you have adjusted the ranges in the formula. Did you?

    See if this works
    B2
    =INDEX(D$2:D$1000,MATCH(A2,C$2:C$1000.0))

    M.
    Last edited by Marcelo Branco; Jun 19th, 2017 at 03:16 PM.

  5. #5
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    12,701
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Take data from two columns and match to another...

    Sorry, the formula above has a typo .0

    It should be
    =INDEX(D$2:D$1000,MATCH(A2,C$2:C$1000,0))

    M.

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
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com