Previous Topic Next Topic

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
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!


Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses