Excel Data - Matching and Sorting
Closed
redhead
-
Jan 13, 2012 at 11:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 13, 2012 at 08:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 13, 2012 at 08:05 PM
Related:
- Excel Data - Matching and Sorting
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 13, 2012 at 08:05 PM
Jan 13, 2012 at 08:05 PM
sheet1 is like this
name contact
a z
s x
d c
f v
g b
sheet 2 like this
id name
1 s
2 f
3 h
4 k
make sure my configuration is same as your data
first copy my data in a new file and test the formula
in sheet1 in C2 type this formula(or copy paste)
=INDEX(Sheet2!$A$2:$A$5,MATCH(Sheet1!A2,Sheet2!$B$2:$B$5,0))
copy C2 down
some rows will have #N/A this means
these names are not available in sheet2
name contact
a z
s x
d c
f v
g b
sheet 2 like this
id name
1 s
2 f
3 h
4 k
make sure my configuration is same as your data
first copy my data in a new file and test the formula
in sheet1 in C2 type this formula(or copy paste)
=INDEX(Sheet2!$A$2:$A$5,MATCH(Sheet1!A2,Sheet2!$B$2:$B$5,0))
copy C2 down
some rows will have #N/A this means
these names are not available in sheet2
