Excel for mac 2016 vlookup how to#

The mechanics of the two functions are very similar, we get similar kinds of results. If we were using the HLOOKUP function, we would be using the other table over here, we'd be getting the same answer. So, ultimately, we will be using a VLOOKUP function here and get an answer of 10%. Since we reach a certain value that's bigger than what we're comparing, we'll go back to here. The logic of both VLOOKUP and HLOOKUP will proceed along the lines of, here's a value, here's a set of values. Now, if we were to look up a value here like 70,000, in a table like this, we will expect to get an answer, and you might not have expected it, but the answer will be 10%. If you have any control over it, put these on the same worksheet where you're gonna be using the formula. Sometimes, they're on the same worksheet. Now, sometimes, tables like this are located on a different worksheet. So sometimes, you'll be faced with the idea, you will be using HLOOKUP or VLOOKUP based on the formulas that are already in place. You might not have the freedom to say, let's just start all over and create new layouts here. And there will be situations where you inherit a worksheet from someone else, and maybe there's a vertical table, maybe there's a horizontal table.

But we could be using either one of them. It tends to be easier to read than the one that's structured horizontally. And, off to the right, we've got two different tables. The two major functions that we mentioned for lookup purposes VLOOKUP and HLOOKUP, are likely to be used in this scenario. We'll have to have nested divs, not a good choice. But, by using an IF function here and trying to taking them out like this 70,000 looking it up on the table. Maybe we don't need to use any so-called LOOKUP functions. Now, possibly, we could be using an IF function here.

We're about to calculate a tax rate here in Column H, and there's a table off to the right. Now, in this particular worksheet here called Lookups, and we're looking at the file called O4-Lookup Functions.

Excel for mac 2016 vlookup how to#

We'll show you how to use these as well in later movies in this chapter. And one other function called CHOOSE is gonna be similar to some of the functions that we'll be using as well. And also point out there are two other functions that we'll use from time to time for lookup purposes, the MATCH function and the INDEX function. And above, we see HLOOKUP, think of H for Horizontal.

The two most important functions for most people, if they are to use any of these functions, are the one we see at the very bottom called VLOOKUP, think of V for vertical. Excel has powerful lookup functions, and if you go to the formulas tab in the ribbon, you'll see a category of functions, it's called LOOKUP and REFERENCE.