For my Google Sheets i need a function that i cant get to work.
In sheet 1 i have the orders with a customer code (column 1).
In sheet 2 i have data of the customers, it is possible that 1 customer has 2 rows in this sheet. So a customer code (column 1) can have 2 rows with 2 times the same customer code and different data. In this sheet is also old customer data, that we do not want to show in sheet 3.
In sheet 3 i want to have a column (column 1) that shows the customer codes. This should be only the customer codes that are in sheet 1, the data should be from sheet 2. Also then both rows should show up.
I tried a lot of formulas but i do not seem to get it working.
Sietse van der Weg is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.