right we've seen several function
combinations so far in this lesson we'll
present another one that can be useful
suppose you'd like to create a table
with the number of people working in
management and admin personnel for
Company D and E again we can use match
to define the column number we need in
the vlookup function
I am sure you now know the first part of
the vlookup function by heart
this will be our lookup value and we
will fix its column reference the entire
table above is the lookup array cool
this is when match comes in play the
lookup value of match will be this cell
when I copy and paste this function I
need this reference to change only when
I move to the right along the horizontal
axis and not to change when I move down
therefore I will anchor its row
reference great in the next step we have
to define the area or the lookup array
where Excel will try to find the lookup
value in our case that means Company D
therefore I will select the header of
the source table and fix it it is not
supposed to move when we copy and paste
the function and this pretty much does
it alright it worked ok for the number
of managers in company D
let's apply this formula to the other
three cells in the table
it works therefore one could combine
vlookup and match in the same formula
from all that you've learned until this
moment you would probably agree that
nesting a match function within a
vlookup differs from nesting columns
within a vlookup though now if I replace
the name of a company with another one
the number of workers in the management
and admin personnel would change
accordingly this is not the case with
the columns function as it works fine
only for adjacent companies in the
source table
thanks for watching