Duplication

%3CLINGO-SUB%20id%3D%22lingo-sub-2403033%22%20slang%3D%22en-US%22%3EDuplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2403033%22%20slang%3D%22en-US%22%3E%3CP%3Ethe%20sheet%20named%20with%20table%20data%20is%20column%20I%20want%20to%20compare%20the%20search%20criteria%20with.%3C%2FP%3E%3CP%3EHope%20you%20can%20help%20me%20to%20search%20with%20the%20criteria%20in%20the%20table%20data%20and%20find%20the%20the%20duplication%20colored.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2403033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2403085%22%20slang%3D%22en-US%22%3ERe%3A%20Duplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2403085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F989570%22%20target%3D%22_blank%22%3E%40MarinaSaadalla%3C%2FA%3E%26nbsp%3BNot%20sure%20what%20you%20want%20to%20show%20as%20the%20end%20result%2C%20but%20in%20the%20attached%20workbook%20I%20determined%20which%20values%20in%20column%20A%20on%20the%20data%20sheet%20(2853)%20exists%20in%20the%20criteria%20list%20(108%20items).%20I%20u%20sed%20XLOOKUP%20and%20VLOOKUP.%20The%20first%20one%20might%20not%20work%20if%20you%20are%20on%20an%20older%20Excel%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20filter%20out%20the%20%22Not%20found%22%20to%20be%20left%20with%20a%20list%20of%20items%20that%20occur%20in%20both%20lists.%3C%2FP%3E%3CP%3EIf%20this%20is%20not%20what%20you%20had%20in%20mind%2C%20please%20clarify.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

the sheet named with table data is column I want to compare the search criteria with.

Hope you can help me to search with the criteria in the table data and find the the duplication colored. 

1 Reply

@MarinaSaadalla Not sure what you want to show as the end result, but in the attached workbook I determined which values in column A on the data sheet (2853) exists in the criteria list (108 items). I u sed XLOOKUP and VLOOKUP. The first one might not work if you are on an older Excel version.

 

Now filter out the "Not found" to be left with a list of items that occur in both lists.

If this is not what you had in mind, please clarify.