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.
2 Comments
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.