Hi team,
I have been trying to solve the below but for some reason, I cannot find a way...any help would be of great help. Attached is a sample workbook for reference. The workbook has the following, the first table has products with a combination of products, these are combinations that are not allowed when a new product is requested.
Table 1:
| Product 1 | Product 2 |
| ABC | DEF |
| ABC | GHI |
| ABC | JKL |
| DEF | ZYX |
| DEF | MNO |
| ZYX | ABC |
| ZYX | JKL |
| ZYX | DEF |
The 2nd table includes sales person and their products for which they are responsible to sell.
Table 2:
| Sales Person | Products |
| John Doe | DEF |
| John Doe | GHI |
| John Doe | MNO |
There would be a form where a sales rep can request a new product to be included in his / her catalog, The check that is required to be perform is to verify if the products already in the catalog i.e., table 2 and the newly requested is a combination that is not part of the combination in table 1. If the product requested is a combination from table 1 after looking in to the existing values, then it should be denied else output should be granted.
Following is a sample of the table with output.
| Input by user(s) | Output |
| Requestor | Requested Product | |
| John Doe | ABC | Denied |
The output result is denied as the requested Product ABC with combination DEF which is already part of the user catalog in table 2 is not a valid combination. Any suggestion, help will be of great help here.
Regards,
A!
https://1drv.ms/u/s!Aj7kf6Fnqc5SyTIwwHjuCtcHIRJT?e=XT7LtZ
