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.
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.