In this video we're going to go over how to use the HLOOKUP formula in Excel. Now, HLOOKUP stands for horizontal lookup.
meaning that whatever data you're going to be referencing or looking up information about
is listed horizontally on your spreadsheet. So, in this case, we're going to be looking up information about our associates and we have
all of the associate names listed horizontally, or across, our spreadsheet.
And then, just below each associate, is the information about them. Now, there's another popular form of look called the VLOOKUP.
That one looks for information vertically, or the data has to be listed up and down your spreadsheet.
If you'd like to learn more about that feature, um,
that formula, please do take a moment to watch my video on using VLOOKUP.
But to get started with this one, we have 2 examples we're going to work on. So, the first one is figuring out what product Sasha sells.
So, to do that, we're going to look...we're going to use the HLOOKUP. So, the formula is =HLOOKUP , we open
our parentheses, and then, in quotation marks, we're going to type "Sasha" because that's text and,
for Excel to be able to read it, we need to make sure it's in quotations.
So, then comma, and then the table array, this is where we choose our data set. So, I'm just going to highlight our entire date set,
then comma and now we need to know
which row number Excel needs to look for the information in. So this data set is made up of 1, 2, 3, 4, 5, 6 -
6 rows. And the information we need, in the "Product Being Sold" is going to be here, in the third one.
So, even though, up here, the associate names look like titles,
for the purpose of the lookup, they're just counted as row 1.
So, we're going to type in 3, then comma, and then False because we want an exact match, and we close parentheses and
the result is that Sasha sells Pillows.
Um, for this next example, who sold the most units, we're going to put in another formula within the HLOOKUP formula.
And I'm going to show you a little way you can cheat using the look up.
Now, one thing to know whenever you're using an HLOOKUP is that
the information that you're looking up, whatever is in this
first part, like how we have Sasha here, whatever is in that look up value has to be your first row.
So,
in order to do that we're going to need to reference Units Sold.
So,
that's going be hard for Excel, with the data as is, to give us the associate name if the associate names are at the top.
So,
we're just going to copy the associate names to the bottom of the data set. Now, your data set may be much longer so you may have to just
scroll to the bottom of it, but this little trick can help save you some time, um,
when you're doing these formulas. So to do this, we're going to type =HLOOKUP
and then, within that, we're going to type the MAX formula.
Now, we're...we need to know what the max, or the highest number is, in the Units Sold. So, we're going to highlight, um, the Units Sold.
And then now we're going to choose our new table array. So, because, again, we're looking up this column, this now needs to be our first
column. So, we're going to highlight all of this
down to the associate name.
And then now we need to let Excel know which row that is.
And the new associate names are in what's now the fourth row of our data range.
And we again want exact data, so we're going to type "False"
and
we know that Buddy sells the most units...and that is true - he sells almost 15,000 units,
compared to everyone else, who didn't even make it to 5,000.
So, anyway, I hope you find this video useful and if you liked it, please make sure to
give it a Like and subscribe to the channel. Thanks!