Vlookup data for duplicate values

[satishwar]

Hi All,

Suppose, I have a data of the customers who ordered multiple times and the order ID is different for every order even the same customer order multiple times and I need to vlookup from data of completed orders, then in this case how can I vlookup the data of duplicate customers...pls help.

 

[Nebu]

Hi:

one way to achieve this is to use a combination of index and aggregate formula.

Thanks

 

[rahulshewale1]

hii satishwar,

if you upload sample excel files we will definitely help you better.


Thanks
Rahul