compare values from 2 columns in excel to find replicartes code example
Example: how to know duplicate in excel in two columns
=INDEX($A$2:$B$14,MATCH("*"&D2&"*",$A$2:$A$14,0),2)
=INDEX($A$2:$B$14,MATCH("*"&D2&"*",$A$2:$A$14,0),2)