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

vlexcel

New Member
Joined
Jun 19, 2017
Messages
2
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...
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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​

<tbody>
</tbody>


Formula in B2 copied down
=INDEX($D$2:$D$6,MATCH(A2,$C$2:$C$6,0))
 
Upvote 0
Thank you for quick reply! I tried it and received the error #N/A.

Here is what I'm trying to do:

b695yh.jpg


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!
 
Upvote 0
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:
Upvote 0
Sorry, the formula above has a typo .0

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

M.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top