Match two rows with same values but not in order excel

[Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
give two examples
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
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.
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
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
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.