yogi_Pull List Data Row By Row For Corresponding ID Entry From Table In Sheet Named SourceData

                                          Google Spreadsheet   Post  #1425
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 20, 2013
question by lsen (http://productforums.google.com/forum/?zx=bqadbhvesqoa#!mydiscussions/docs/47O-vkB-Dzw)
Arrayformula with Concatenate and filter, but problem with Filter


Found a small hiccup.

If a number is entered that is not on the source list, it is treated as if it wasn't there. but will populate the information of the next item that is on the list.

ID	List
1004	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
56	11/7/2013: Contract Created 11/8/2013: Contract Verified 11/9/2013: Payment Verified
1	11/11/2013: Started to Run 11/12/2013: Ran 1 Mile 11/13/2013: Ran 2 Miles 11/14/2013: Bought supplies
1003	11/7/2013: Contract Created 11/8/2013: Contract Verified 11/9/2013: Payment Verified
1001	11/10/2013: Payment Received 11/11/2013: Contract Verified
1003	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
1002	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
1004	11/12/2013: Walked Home
1004	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
1005
1004

-------------------------------------------------------------------------------------------------