Match two rows with same values but not in order excel

Closed
NewBee - Apr 4, 2011 at 09:35 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 5, 2011 at 05:34 AM
Hello,

I'm New bee if some one could help, I wanted to match coloumn B with the values of column C which has the same values as C but less in number and not in order. Further more to that I have column D which has the same value as Column C but they are pefectly match and while using the formula I do not want to disturb the matching values of Column C and D. So basically I wanted to find the matchin values of column B with Column C but not distubing the values in column C and D

This should Explain more

A B C D
0 m n n
1 n s s
2 s r r
3 o l l
4 l m m
5 k o o
6 r k k
7 b b
8 d d
Now without distubing C and D i wanted to match the B column with C,



4 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Apr 5, 2011 at 12:15 AM
give two examples
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 5, 2011 at 02:33 AM
Use Vlookup as in column E1;


=vlookup(B1,C:C,1,false)

and drag it to last row.

where you got the same value it match with B and for #N/A is not matched cells.
0
Hi RWomanizer,/Venkat,

Let me make my self clear once again. I have some 2000 entries in column B and more than 35000 entries in Column C and D respectively( and they are matched properly). Now I wanted to use a formula in E in such a way that Column B's value should match to column C. But problem for me is B and C columns, even though have same values but they are not in order.

A B C D
0 m n n
1 n s s
2 s r r
3 o l l
4 l m m
5 k o o
6 r k k
7 * b b
8 * x x
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 5, 2011 at 05:34 AM
what value you want in column E, please clear it. if you want like this

A B C D E
0 m n n m
1 n s s n
2 s r r s
3 o l l o
4 l m m l
5 k o o k
6 r k k r
7 * b b *
8 * x x *

then use above formula. in column E,
otherwise please describe why you want to like this, or what analysis you want to perform.
0