Alex Juel – SEOHolicc’s SEO Blog

Internet Marketing and SEO

Why SEO?

Increase the amount of visitors to your website. Drive relevant traffic and rank high in the search engines, organically and locally.

How to Compare Two Lists in Excel

Knowing how to compare data from two different columns in Excel using the VLOOKUP feature is something that can be super useful for internet marketers or anyone who deals with data regularly. The other day I did some competitive research to gather backlink data from various websites, many of which had backlinks from sites I’ve contacted in the past. I wanted to make sure not to contact these sites again, so I needed to weed out the URL’s that matched in both lists.

I’m on a Macbook and using VBA code isn’t available in Excel for Mac, so I had to find a formula, which I did after a long search. Start by putting the longest list in Column A and the shorter list in Column B. In Column C enter =VLOOKUP(A1,B:B,1,FALSE) and copy the formula down to the last cell where data ends in Column A.

A1 = The cell being compared
B:B = The set of data Column A cells are being compared to
1 = Tells the formula to return a result from of data matches
FALSE = Tells the formula to return an exact match

Tip: If you’re using this to compare deep URLs but need to compare to domains, use Ontolo’s URL & Hostname Counter, set to Count Hostnames and click the button. Copy to Clipboard and paste into Excel.

Be Sociable, Share!
  • How to Compare Two Lists in Excel
If you enjoyed this post, make sure you subscribe to my RSS feed!

3 Responses to “How to Compare Two Lists in Excel”

  1. Sweet tip man – thanks!

    Jason Lancaster

  2. No problem Jason :D If only I would’ve figured this out years ago.

    SEOHolicc

  3. LOL – I feel like I say that every day.

    Jason Lancaster

Leave a Reply