I was asked for my Top 5 Excel Functions. Number 2 is VLOOKUP.
This video goes along with a blogpost on my site:
In this video I show 2 ways that VLOOKUP can be used:
1. How do we determine which of our members HAVE NOT replied to their invitations?
2. How to retrieve data from a master list to round out an incomplete list