So I want to take just a second to talk about something called named array's.
Before we dive into specific lookup functions named arrays are a really nice tool to help you simplify
your Look-Up functions especially if you find yourself using the same exact data array in multiple places
or across multiple formulas.
So for example if I have product level data in cells a 1:36 and I'm using this exact data reference
in a number of places I could give it a name.
In this case I'm calling it a Aperol so that in the future when I write formulas that refer to this
array I can either write a one call and D6 or I can just write Aperol which is the name that I've assigned
to this array.
So Excel will recognize that and understand that I'm talking about the array from A1 through D6.
So let's jump into Excel and take a look at the file that we're going to be working with.
Section 5 look up reference.
We've got four tabs here.
The first tab called hitting data is one of our raw data tabs.
We've got player names.
Years and then a bunch of hitting data metrics in columns C and fielding data.
We also have a player in your column and then some additional fielding data metrics and see gee we've
got a price checker tab which are populating.
Once we learn how to use index and match and combine the two and then we've got scroll chart which is
going to be a really awesome tool that we're going to build using the offset function.
We're going to create a chart that can be scrollable and zoom mobile and dynamic and basically do stuff
that most people would never think Excel is capable of.
So really excited to share that.
But jumping back to the concept of named arrays Let's show an example it's go to the fielding data tab
.
If I want to use this entire array on this tab for something like a lookup function what I can do is
click on A-one control shift arrow right arrow down so that I've got the entire array selected in the
first way to define this as a named array and stick click on this box here which is the name box and
just give it a name.
I'm going to call it Fielding.
And now if you go into the formulas tab click the name manager you'll see that it's created a new named
array called fielding that refers to the fielding data tab A1 theurgy twelve thousand fifty six which
is exactly what I just selected.
I'm going to show you one other way to do that.
So delete this yes.
Close this box and now instead the other option is to start in the formulas 10.
Click on this define name button.
Give it a name or call it fielding again.
I can add a comment if I want.
This is fielding data.
And then click the data selector button and then select that exact same array that I just did press
the button again and lock it in.
So I have to go back to the name manager.
You can see the same exact thing happened it created a new named a called fielding that refers to a
1 or G 12:56 on the fielding data tab.
So there you go.
That's a great name to raise