Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Excel Data - Matching and Sorting [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 -
Hello,

I have 2 spreadsheets, Spreadsheet 1 with names and contact information, and SS 2 with contact information and an ID number. Names are in Column I on SS1 and Column B on SS2. The ID numbers are in Column A on SS 2.

I need to take the ID numbers from SS 2 and match them up with the right names on SS1.

I am sure there is a way to do this with vlookup, but after researching and trying to learn it, I just can't figure it out.

Any help would be greatly appreciated.

Thanks in advance!


See more

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 792
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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!