I don't know what do you mean by "find duplicates", but VLOOKUP has a option to specify an exact match so you can use it even if the data is not sorted (MATCH d

I don't know what do you mean by "find duplicates", but VLOOKUP has a option to specify an exact match so you can use it even if the data is not sorted (MATCH does as well).