Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/

During this Microsoft Excel 2016 advanced training tutorial video, we will demonstrate a simple LOOKUP function which is the CHOOSE function. We will also be creating a QUARTILE function and then we will be showing you how HLOOKUP works.

Check out some of our other training on YouTube:

Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h5ZVxzp_a4UHRQBtXXgnxf

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

Hello again and welcome back to our course on Excel 2016 Advanced.

In this section we’re going to take a look at LOOKUP and Reference functions. And in particular we’re going to start looking at LOOKUP functions. And as the name implies what we do with a LOOKUP function is looking up a value in some kind of index or a list and using the returned or identified value.

Now I’m going to demonstrate first a very, very simple LOOKUP function which is the Choose function. It’s really quite limited in what you can do but it’s a very easy function to use and you may well come across situations where it does the job for you.

So by way of a very straightforward example of this let’s suppose that I have some responses to some survey types of question. And people give a numeric response in the range one to five. And each of those numbers corresponds to a phrase. And in a particular situation I want to not only show the response as a number but also the phrase that it’s equivalent to.

Now the way that I can do that in this case, I’m going to put the phases in column D is to use the Choose function. Now I can either start typing =CHOOSE or I can go to LOOKUP and Reference and there is the Choose function. And first of all, first argument, is the index number. So this is the number that we are going to look at and use as the basis for our choice. Now for D3 the number I’m going to be looking at is the number in C3.

The next argument is the value I’m going to put into D3 if the value in C3 is one. It always starts at one. So I’m going to say that one corresponds to strongly agree. Now I put in the next value. A value of two corresponds to agree. A value of three. Now I can have up to 254 values there. So at the moment I put in five values, which means in this case that I can accommodate numerical values in C3 from one to five.

Now all the time that there is nothing there then I’m going to get an error message, in this case #VALUE!. I’ll come back to that in just a moment. Let me now put a number in there, 2. That’s agree, 4. Now as you can see that’s pretty straightforward. Now Choose always works with positive integer values starting at one on a continuous scale. If in fact in the response there I put something like 3.6 what Excel 2016 does is to round that down and it will give me the equivalent of if I’d put three in there. I need that to be a little bit wider.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.