VLookUp Introduction
In this lesson we’re going to explore and explain an Excel VLOOKUP function.
I want you to think of the process of your VLOOKUP like your manual process for searching a phone book. What are you looking for ? (i.e. the name), Where are you going to look? (i.e. which page), What do you want to look up the name for? (i.e. to get the address from the second column? or the phone number from the third column?). This is the information you need to get a phone number from a phone book and it’s also the process that Excel needs to follow as well – we just have to give it the information.
Download the activity file here before starting the tutorial.
Hopefully you’ll have a better understanding of how your VLOOKUP works by the end of the video.
Cheers,
Danielle