#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Match to table daniellchiu via OfficeKB.com Excel Worksheet Functions 1 September 19th 07 03:52 AM
MATCH a value in a table Kevin Rodriguez Excel Worksheet Functions 11 December 6th 06 08:57 PM
two table lookup match IntricateFool Excel Discussion (Misc queries) 12 October 3rd 06 09:50 PM
Two column value match table look up John Excel Worksheet Functions 4 March 2nd 06 02:20 AM
HLOOKUP last match in a table [email protected] Excel Worksheet Functions 3 January 5th 06 09:31 PM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"