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
    13,233
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    3 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
    13,233
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    3 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
    13,233
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    3 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
  •  


DMCA.com