0:01
hi and welcome back to Excel Wiz In this
0:04
video I'm going to show you how to use H
0:07
lookup in Excel and show you the
0:09
difference between H lookup and V lookup
0:15
started H lookup This is a function in
0:18
Excel that is normally used to search
0:20
for a value in the top row of a table
0:24
and then it returns a value from the
0:27
column in a specified row For example in
0:32
this video I'm going to show you how we
0:34
can use hookup to check for the value in
0:38
metric tons of soya beans for the food
0:41
commodity soy beans So as you can see
0:45
soy soybeans is on the first row while
0:49
500,000 metric tons is on the same
0:53
column So this is how it goes So we'll
0:56
start by typing in our H lookup
1:05
formula H lookup formula just like the
1:08
VLOOKUP has four parameters The first
1:12
one is the lookup value This is um this
1:16
is now the value that you're going to
1:18
search for in the first table in the
1:21
sorry in the first row of this table For
1:23
example our first parameter is going to
1:29
uh I3 which is soybeans Our second
1:32
parameter is going to be that uh the
1:36
data the range of cells that's
1:38
containing the data In this case we're
1:40
going to now select all our
1:44
cells Our third parameter is now the row
1:48
number in the table from which the
1:51
matching value must be matched So the
1:55
row starts from here 1 2 3 4 5 So our
2:00
value that we need returned is on row
2:03
number five So the parameter is going to
2:06
be five And the last parameter
2:09
now is the exact match or the
2:13
approximate match In this case please
2:16
ensure that you always put false which
2:19
which means that you're looking for the
2:21
exact match unless you have a really
2:24
good reason as to why you want to use
2:26
true which is approximate match So in
2:28
this case let's go on with
2:32
false and enter As you can see the value
2:36
that we are looking for is 500,000
2:38
metric tons which is what uh we've we
2:42
had with H lookup So that's how you
2:46
actually do hook up in Excel So just
2:49
ensure that you know the parameters and
2:52
how to use them It's the same thing with
2:54
VLOOKUP I'll just use the same example
2:57
just to show you the the difference
3:01
So with VLOOKUP this is now used to
3:05
search The VLOOKUP function in Excel is
3:08
now used to search for a specific value
3:11
in the first column of a table and then
3:14
returns it returns a value from the same
3:17
row in a different column For example
3:20
let's use a different food commodity In
3:23
this case we want to know um the metric
3:29
oil And now we will use VLOOKUP for this
3:32
So let's start with the VLOOKUP
3:40
formula And as I said before the VLOOKUP
3:44
formula and the H lookup formula are the
3:46
same The parameters are the same Just
3:48
the only difference is the arrangement
3:51
of the data In VLOOKUP your data must be
3:55
um arranged in vertical order while in H
3:59
lookup your data has to be arranged in a
4:02
horizontal way So the first parameter is
4:06
going to be the value to search for in
4:08
the first row In this case our value is
4:11
palm oil which is B10 Our second
4:14
parameter is going to be the data uh the
4:19
cell the data range which is going to be
4:23
all the data in our table Select it That
4:27
parameter is going to be the um column
4:31
number in the table from which the
4:33
matching value must be returned Our
4:36
column first column 1 2 3 4 5 We can
4:41
actually look for the import country
4:45
uh for palm oil it's going to be 1 2 3 4
4:50
We are looking for the Netherlands so
4:52
it's going to be four And now our
4:55
last parameter is going to be false
4:58
which should be the exact match And
5:01
there you go So the value that we
5:04
actually looking for is the Netherlands
5:06
And that's it If you have a question
5:09
regarding a VLOOKUP formula or H lookup
5:12
formula please feel free to leave a text
5:15
down in the comment section and see you
5:18
again next time Thank you for watching