Forum Discussion
jbbarnabas
Sep 04, 2020Copper Contributor
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...
jbbarnabas
Sep 07, 2020Copper Contributor
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.
SergeiBaklan
Sep 07, 2020Diamond Contributor
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).
- jbbarnabasSep 08, 2020Copper Contributor
For now this formula works perfect.
Thanks for your input.
Hope someone will assist with a more dynamic approach.
Thank you.
- SergeiBaklanOct 01, 2020Diamond Contributor
jbbarnabas , you are welcome