In this tutorial of almost 20 minutes, I show you:
– Several practical examples of when and how to use the VLookup and HLookup functions
– The differences between the 2 functions
– The difference between TRUE and FALSE (4th Argument)
The video was recorded using Excel 2011 for Mac but everything I demonstrate works equally well on Windows
Thank you for the video. Based on your video above, what if you have two salaries, for each of the positions, can you do a VLOOKUP and sum the two salaries in the Salary column on the first table?
Amazing. You are a Champ!