yogi_ From Table Of Invoice Information With Names In Columns Pull Invoice Info By Specified Name

                                         Google Spreadsheet   Post  #1633
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-10-2014
post by: Daniel Abud (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/YYCic9dW63g)
Filter + HLOOKUP to sort data by date
So I have customer information and quantities that each customer has purchased or used. I need to create invoices for each customer. I currently have a filter function that only kicks back the days that are relevant to each customer. Here is my data:

                Bilbo   Rohan
               
               
12/9/2013        1        5
12/12/2013                5
12/16/2013        2        5
1/7/2014                5
1/8/2014        1        5
1/10/2014                5
1/11/2014                

This is my filter:
=filter(D9:D15,NOT(ISBLANK(E9:E15)))

These are my filtered dates and customer hours (essentially an invoice):
12/9/2013        1
12/16/2013        2
1/8/2014        1

Is there any way that I can automate the filter so that all I have to do is type "Bilbo" into a cell and it will automatically give me Mr. Baggins' invoice?? I currently have to go into each individual invoice and change the cell number - which is very time consuming when you're trying to just spit out invoices for multiple customers.

Thank you!

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