Forum Discussion
Match Function - Checking various sheets
Good day community. I need assistance please. I need to see if Data is dupplicated in various sheets. I currently use a match function ,but I`m 1unable to set the range of the match lookup a...
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