Thread: Match Table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daniellchiu via OfficeKB.com daniellchiu via OfficeKB.com is offline
external usenet poster
 
Posts: 10
Default Match Table

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

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