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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"daniellchiu via OfficeKB.com" <u36625@uwe wrote in message
news:786e09eb32934@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200709/1