Display a list of data based on value in a cell

Hi.

I am trying to generate a statement of account from a database. The idea is to enter the Customer ID in cell A1 (example), and have the list of invoice numbers, invoice dates and invoice values appear in columns B, C and D.

Any idea how I can achieve this? (Pivottable is not ideal).

Thanks.

Can you post a sample of your data so that we can see exactly what you are dealing with?