Forum Discussion
Match Function - Checking various sheets
It rather depends on the layout of the data you are trying to compare. If you were looking for duplicate records in similar tables then Power Query might be to best solution. An Append Query would combine the Tables in memory. Then first 'Keep duplicates' and then 'Remove Duplicates', to avoid retaining multiple copies of the duplicated records, would provide a list of the records held in duplicate.
The example as below:
The result needs to tell me when a row data is duplicated in one of the other sheets
Main Sheet:
| Vendor | Price | Date | Product | Dupplication Result |
| A.Small | 200 | 01.01.2020 | PC Mouse | |
| B.Big | 300 | 01.02.2020 | PC Screen | |
| C. Average | 500 | 01.03.2020 | Keyboard |
Sheet 1
| Vendor | Price | Date | Product |
| A.Small | 200 | 01.03.2020 | Keyboard |
| B.Big | 300 | 01.02.2020 | PC Screen |
| C. Average | 500 | 01.04.2020 | PC Mouse |
Sheet 2
| Vendor | Price | Date | Product |
| A.Small | 200 | 01.01.2020 | Software |
| B.Big | 300 | 01.02.2020 | Printer |
| C. Average | 500 | 01.03.2020 | WIFI |
Thank you.
Straightforward way is
but it's much better to use dynamic ranges (or fixed but not entire columns).
Actually the same idea with Power Query (table at the right).
For now this formula works perfect.
Thanks for your input.
Hope someone will assist with a more dynamic approach.
Thank you.
jbbarnabas , you are welcome
