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
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 5, 2011 at 05:34 AM
Related:
- Match two rows with same values but not in order excel
- Number to words in excel - Guide
- Screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
- Position formula in excel - Excel Forum
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 5, 2011 at 12:15 AM
Apr 5, 2011 at 12:15 AM
give two examples
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Apr 5, 2011 at 02:33 AM
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.
=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
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
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Apr 5, 2011 at 05:34 AM
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.
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.
