View attachment Excel_issue.xlsx
hi all,
Please find attached the excel sheet for reference.
Problem:
hi all,
Please find attached the excel sheet for reference.
Problem:
- In Tab 'Sheet 1':
We have supplier- Customer Relationship. Each Supplier can Supply products to multiple customers.
In Sheet 2:
We have list of the products that each supplier can supply. Each supplier can supply multiple products.
Result:
Against all the supplier -customer combinations in Sheet1.We want to include the products from sheet2, as they are supplied by the supplier.
So if any supplier is supplying 3 products, then there should be 3 lines for that supplier - customer combination in Sheet1. With different products in each line (as shown in result sheet).
And this should happen every time that supplier is there.
Can anyone please help me, how can we get this data?