I have Table 01: Product
Columm Price option : $1 , $2 , $3
Table 02 : Customer
Column Want to buy at : $1, $2, $3
I want to match these condition together and display its at another sheet and i can track back which customer is which.
Example : Display sheet will be display:
Product A price $1 have : Mr.A , Mr.B, Mr.C, Mr.D want to buy
Product B price $2 have : Mr.A, Mr.B want to buy