Instructor: All right, welcome to Section 5
Lookup/Reference Functions.
Now, we're starting to get into some
of the really, really powerful, heavy-hitting formulas,
so I can't wait to get started.
In this section, we're gonna talk about named arrays
which is a way to more efficiently work
with your lookup formulas
in cases that you're using the same arrays over and over.
We'll talk VLOOKUP and HLOOKUP
which are kind of two classic lookup functions
that are used all the time in Excel.
We're gonna talk about some formulas
like ROW and ROWS, COLUMN and COLUMNS
which can be really interesting components
as part of other lookup functions.
We'll go into INDEX and MATCH,
talk about how to combine those,
how to use MATCH with a VLOOKUP function
to do some really powerful stuff.
And then we'll talk OFFSET which is a somewhat complicated
but really, really interesting formula.
And we'll do an Excel demo during that lecture
where we're gonna build this dynamic chart
that can scroll and zoom and move, basically do some stuff
that most people would never think Excel is capable of.
We've got two files for download.
Got the PDF and the Excel file, Section 5 Lookup/Reference.
So go ahead and download both of those,
and let's get ready to roll.