array; vlookup

  1. C

    Array vlookup with multiple results

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

Some videos you may like

This Week's Hot Topics