title: Find out if a combination of 2 Cells values right next to each has been entered previously in 2 columns
body: <p>So I have column A and B, we manually enter the values of this 2 columns to record when we change from Part A to Part B, if its in the file it means the change could be performed after some investigation. We do this manually every time a change of part number is requested.</p>
  
  <p>To avoid this search with manual search or filtering, I want to know if its possible with an Excel Macro or a function to search in the whole columns if the combination of the values in, for example, A2131 &amp; B2131 have been entered before (For example it was entered before in A1521 &amp; B1521), and if yes, return a 1 or a yes, or anything that tells me it has been done before, and if it isn't, return something else.</p>
  
  <p>I have tried to use vlook up, but I can only compare one column vs another, is there a way to compare 2 columns for example, which is what I need.</p>