How to Match to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

daniellchiu - 19 Sep 2007 03:40 GMT

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

Reply to this Message

Max - 19 Sep 2007 03:52 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> A B
> 1001 166
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message