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