Wednesday, November 20, 2013

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.

IDList
100411/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
5611/7/2013: Contract Created
11/8/2013: Contract Verified
11/9/2013: Payment Verified
111/11/2013: Started to Run
11/12/2013: Ran 1 Mile
11/13/2013: Ran 2 Miles
11/14/2013: Bought supplies
100311/7/2013: Contract Created
11/8/2013: Contract Verified
11/9/2013: Payment Verified
100111/10/2013: Payment Received
11/11/2013: Contract Verified
100311/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
100211/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
100411/12/2013: Walked Home
100411/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
-------------------------------------------------------------------------------------------------