Thanks:  0
Likes:  0

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

1. ## 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. ## 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. ## 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. ## 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.

5. ## 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

#### Posting Permissions

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