ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Match Table (https://www.excelbanter.com/excel-worksheet-functions/158836-match-table.html)

daniellchiu via OfficeKB.com

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


Max

Match Table
 
See one response to your earlier posting

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





All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com