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

    I am very passionate about helping legal professionals succeed. I even quit my day job to devote more time to mentoring! I want to encourage you to subscribe and join the LitSuppGuru community. I share humorous, informative, and time-sensitive emails above and beyond what appears on this site.

    Please note: I reserve the right to delete comments that are salesy, offensive or off-topic.

    • mgolab

      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.

      • Wow, that’s a lot of lookups. Ha! Thanks for adding your important point.