pull data from one sheet to another by match

[eric.l.bohon]

ALCON,

What I am trying to do is easy but do not know exactly what the code is.

What i want to do is pull data from one sheet to another by matching one column with another column. here is the example:

sheet one

cell one: name

sheet two

cell one: name
cell two: ssn

So I want to pull ssn in on sheet two onto sheet one

any help on this.

 

[snoopyhr]

Maybe something like this : ?

the table in on sheet 2

Excel Workbook
	A	B
1	Names	SSN
2	Name-1	123-13-1234
3	Name-2	123-13-1235
4	Name-3	123-13-1236
5	Name-4	123-13-1237
6	Name-5	123-13-1238
7	Name-6	123-13-1239
Sheet2

Excel Workbook
	A	B
1	Names	Extracted
2	Name-1	123-13-1234
3	Name-2	123-13-1235
4	Name-3	123-13-1236
5	Name-4	123-13-1237
Sheet1

 

[snoopyhr]

needed correction:

=INDEX(Sheet2!$B$2:$B$7,MATCH(Sheet1!A2,Sheet2!$A$2:$A$7))
the above formula should be :

=INDEX(Sheet2!$B$2:$B$7,MATCH(Sheet1!A2,Sheet2!$A$2:$A$7,0))