Excel Data - Matching and Sorting

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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!


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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