0:00
Welcome to our course Excel fundamentals
0:02
formulas for finance it can be a little
0:05
bit overwhelming in Excel sometimes cuz
0:07
there are literally hundreds if not
0:09
thousands formulas and functions in the
0:12
software and it's hard to know which
0:14
ones are the best ones to use within the
0:16
finance profession so this course
0:18
effectively filters and sorts through
0:21
all of those formulas and functions to
0:23
focus you on the ones that are the most
0:26
important for financial analysis so in
0:28
this video we're going to take a look at
0:30
the X lookup function and it's really
0:32
better than the H lookup and vlookup in
0:35
every way first of all the single X
0:37
lookup function replaces both of those
0:40
functions and also it's not prone to
0:43
errors that can get caused by users
0:45
inserting rows or columns overall it's a
0:48
better function and you're going to see
0:50
it's much more simple let's jump in and
0:52
take a look at how it works so in this
0:55
area where it says X lookup one we're
0:57
going to look at how the X lookup
0:59
function can work in a horizontal
1:01
fashion so let's pop into this cell and
1:03
type equals XL right away the function
1:06
name comes up we can hit the Tab Key now
1:08
the lookup value which is the first
1:10
argument is going to be the same we're
1:12
just going to select item number four
1:14
put in a comma well now it's looking
1:17
specifically for the lookup array so
1:20
where should it look for item number
1:21
four well we're going to select right
1:23
here all the way across just to include
1:26
these item numbers now we put in a comma
1:29
and now it's asking for the return array
1:32
and we're going to select one row right
1:35
here where all the commissions can be
1:37
found what we can do now is just close
1:40
the bracket and hit enter so now let's
1:42
build up an X lookup function down here
1:45
in a vertical fashion so we're going to
1:47
hit equals XL function name comes up hit
1:51
the Tab Key the lookup value is going to
1:53
be here item number four let's put in a
1:56
comma for the lookup array we're going
1:58
to select all all the way down here
2:01
vertically and then we're going to put
2:03
in a comma and for the return array
2:06
we're going to select these commissions
2:08
that are from here all the way down to
2:10
here then we can close the bracket and
2:12
hit enter as we mentioned earlier the
2:14
entire Library functions available in
2:17
Excel can be very overwhelming this
2:19
course will save you immense amounts of
2:22
time by helping you sift through Focus
2:24
only on the functions which are the most
2:26
effective within the finance industry
2:29
there's lots of the cover so let's get
2:31
in there and get started
