How to Match to table

[daniellchiu via OfficeKB.com]

A B
1001 166
1002 126
10021 132
1003 879
1004 200

How to I find Column A and return Column B value in this table to another
table become

A B
1001 166
10021 132
1004 200

Thanks

 

[Max]

One way is VLOOKUP

Assuming source table is in Sheet1, cols A and B, data from row1 down

In Sheet2,
where you have the other table

Put in B2: =VLOOKUP(A1,Sheet1!A:B,2,0)
Copy down