mrxlsx
Board Regular
- Joined
- Dec 15, 2012
- Messages
- 95
Hi Good evening all,
I have a Sales report which has many duplicate Invoice nos. I have a Drop-down in cell J2 which fetches me all the unique Invoice nos. I want to fetch all of the Invoice details like Products Ordered, CustomerName, Qty, Rate, Amount etc when I select Invoice no from the Drop-down.
Here is the Problem:
I have many Products and other details attached to the same Invoice in the Sales report. I might have run a simple VLookup or Index Match if the Invoice is having only one record/row of information. But sometimes it is having 10 different Products bought by the same Customer. How to fetch all the Invoice details. Please guide me! Thank you so much in advance.
For your quick understanding of the problem please follow this link.
https://drive.google.com/open?id=0B6GD5M1_zN7bSnNrUm9La1RFc00&authuser=0
mrxlsx
I have a Sales report which has many duplicate Invoice nos. I have a Drop-down in cell J2 which fetches me all the unique Invoice nos. I want to fetch all of the Invoice details like Products Ordered, CustomerName, Qty, Rate, Amount etc when I select Invoice no from the Drop-down.
Here is the Problem:
I have many Products and other details attached to the same Invoice in the Sales report. I might have run a simple VLookup or Index Match if the Invoice is having only one record/row of information. But sometimes it is having 10 different Products bought by the same Customer. How to fetch all the Invoice details. Please guide me! Thank you so much in advance.
For your quick understanding of the problem please follow this link.
https://drive.google.com/open?id=0B6GD5M1_zN7bSnNrUm9La1RFc00&authuser=0
mrxlsx
