Skip to main content

Need help ! I want to draw data from both sheet and display it in others sheet

  • June 6, 2021
  • 0 replies
  • 3 views

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