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 johnlegge@jplcomputer.co.uk or give us a call on 07903 840105.

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