Array vlookup with multiple results

[Clare1805]

I have a sheet called DATA which has customer ID and all of the products they have ordered.

what I hope to do is the following: In a seperate sheet, a user enters the Customer ID and all of their orders are displayed below (with duplicates and all on seperate rows) - I have tried an array vlookup formula but keep getting the first product the customer ordered repeated down the page - any ideas?

Thanks in advance.

 

[Yard]

Sounds like a job for a Pivot Table.

Won't teach you to suck eggs, so post back if you need some guidance.

 

[stanleydgromjr]

Clare1805,

You could use "Data Filter Advanced Filter with Critera and Extract ranges and Command Buttons".

See my attached workbook:
http://www.excelforum.com/excel-wor...d-data-in-a-table-based-on-an-input-cell.html


See my Private Message to you (top right hand corner of MrExcel, Welcome, Clare1805., "Private Messages:".


Have a great day,
Stan