MS Excel course – looking at the VLOOKUP function and the different arguments available

The VLOOKUP function. It is a function that a lot of people either use or want to know how to use! It is a very useful function that can be a very powerful tool for you in your work and can save a lot of time in linking spreadsheets! With some functions in Excel, you can sometimes kind of muddle through and work out how they work (roughly!), however the VLOOKUP function has a bit more to it and so is a bit harder to just ‘pick up’ by yourself.

As the VLOOKUP function is a bit more advanced, we thought that we would do a video explaining how it works! Following written instructions is a good way of learning how to do something, but sometimes hearing the steps being explained verbally makes it a bit simpler to follow!

Below is a video of how to use the VLOOKUP function with both the TRUE and FALSE arguments. The video will take you through each step as we type in the VLOOKUP function in Excel explaining what we do and why.

Have any thoughts about this hint and tip? Get in touch and let us know! We hope it helps you with your knowledge of Excel!

If you liked the video above, do let us know! We always like to have feedback from anyone who has looked at a hint and tip of ours.

If you want to know more about any MS Excel course that we offer or any other course in the Microsoft Office modules that we offer, then do get in touch by emailing us on or give us a call on 07903 840105.

We are always happy to help anyone in the development of their Microsoft Office knowledge!

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy