Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default match, lookup ???


in column a2:a1001 i have 1000 number
in column b2:b1001 i have 1000 names and addresses
in column g2:g32 i have the numbers 1 thru 31
in column h2 to h32 i will draw a sample of 31 and plaace in column
a2:a1001

here's the problem, if the sample drawn numbers match the numbers in
column a2:a1001 i want the drawn numbers placed next to the numbers in
column a2:a1001.


--
skimpw
------------------------------------------------------------------------
skimpw's Profile: http://www.excelforum.com/member.php...o&userid=37480
View this thread: http://www.excelforum.com/showthread...hreadid=571392

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
Lookup? Match? pulling rows from one spreadsheet to match a text f cjax Excel Worksheet Functions 3 July 21st 06 02:51 PM
Double and Multiple Lookup Using the MATCH Function Charles793 Excel Worksheet Functions 0 May 11th 06 01:46 PM
Match Index Lookup Kevin Excel Discussion (Misc queries) 1 March 17th 06 04:40 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Lookup then Match and insert value from next column Tenacity Excel Worksheet Functions 3 March 4th 05 02:49 AM


All times are GMT +1. The time now is 11:14 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"