Excel Data - Matching and Sorting Closed

Question

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!


Configuration: Windows 7 / Firefox 9.0.1

venkat1926 · Answer

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

Excel Data - Matching and Sorting

1 response

Similar discussions

Subscribe To Our Newsletter!