MS Excel Course – looking at the 2 arguments of VLOOKUP!

MS Excel course vlookup: Excel icon

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

This week we are bringing you a hint and tip on the VLOOKUP function in Excel.


VLOOKUP Function

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.

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. Why not take a look at our previous post on Excel tips to help you learn Excel?

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 use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

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