Excel Data - Matching and Sorting

Closed
redhead - Jan 13, 2012 at 11:41 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jan 13, 2012 at 08:05 PM
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

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