Match Table

[daniellchiu via OfficeKB.com]

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

Table 2
A B
1001 166
10021 132
1004 200

I want to Seach from Table1 Column A which match the Table2 column A,
afterthat return the value

Thanks

 

[Max]

See one response to your earlier posting