> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.accessorange.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Compare 2 columns in excel

Articles on: [Excel](/en/category/excel-1x4hvac/)

## Compare 2 columns in excel

  
  

  
  

  
  
*   Conditional formatting Select both column
  
  
                Conditional formatting, highlight duplicate with color  
  
                Conditional formatting, highlight unique with different color  
  
*   =Vlookup(A2, select range and lock,1,0)
  
  
![](https://storage.crisp.chat/users/helpdesk/website/2143b849f702ae00/4c277b9f-3011-4443-bc98-c1f7a1_1my14h7.png)  
  
*   =iferror(vlookup(a1, b1:b35,1,0), “not found”)

Updated on: 31/01/2023