Fast Tip Friday – Using Excel VLOOKUP to Compare Lists of Bates Numbers

This fast tip demonstrates how to use the VLOOKUP function in Excel to compare two lists of bates numbers and then a couple of ways to visually present the results.

In a previous fast tip, I demonstrated an alternative way to use Excel to compare two lists.

Download Sample Files


  1. Great tip Amy. I only use vlookup about every 2-3 hours of each and every day at work.

    One further point, we tend to sort both lists in the same order first as I think there was a time back in the dim past when we didn’t and had some false results.

Leave a Reply

Your email address will not be published.