8 hours 33 minutes
we're continuing this
lesson with the lookup function
and look up function
simpler version of bee. Look up in H look up
and it's basically there for backup. Oh, are backward compatibility with previous versions of Excel.
my shoulder, once so look up looks a value. The first argument from one row or common an array
and returns the value from the other column or row in the same array.
You don't have to specify the whole ***. It's much simpler to use, and sometimes it makes more sense to use it
and just to see how it's done. So we have. Look up,
We're looking for this value here.
And then we look at this range here and we expect the answer from this range. Here
it has the same limitation, like
the V Look up.
It expects that all of these air different or if there are two of the same,
it will return the 1st 1 So, for example, if he
are looking for Johnson and we,
they have Johnson here.
We won't get Jenise. We'll get Mike because Mike is the frizz Johnson in a list.
And it's simple. Is that So, uh,
this is a limitation off dysfunction, but it works very nicely if we know that all off data is different.
nothing special about it. Just continue with their functions.
So next on his match
and Millie match returns a relative position often item in the ray.
So let's, uh, look att how it
we say here mad
and then we look att This will you here.
And we have look up array. And this can be this
reaches clothes and presenter and we get four.
But if we air, for example, in this function going that from position or one that from physician three get to. So if we're looking for this number here which can be a variable because it can also be a seven,
it will give us position within the rare. Also, this disarray doesn't have to be,
you know, just 12345 It can be whatever it can be.
A list of numbers which are random
again. The limitation of my trunk shin is that it will simply stop when it finds the 1st 1 Because if you type seven here is well,
nothing will change
it won't find this one. It will find just the 1st 1
What can be done if you're looking for more of them that in the next search you can start from position which is this one plus one?
We had that with text strings when we were looking for the second space in the street. Take string. So you understand that
the logic is the same
in slightly different here. So for example, here we would go
match, then open
and then we look
and then we would need to look from the cell, which is it would make things complicated. We will need to use some text functions and then other functions.
I won't go into this,
it can be done.
So the next function is transposed
and transpose is actually the last function that we're going to mention here.
And transpose simply transpose is a row into cone and coal into row.
And I show you this for on an example. So we have these six numbers we want to transpose them in. Thes excels. So we have to act like this is in a ray function because it is
miss a transpose open bracket. Selecting the ray.
It has to be the same size.
it doesn't work like that. Yeah,
and this is very simple because I haven't pressed control Shift enter.
It's a very nice too
Come here and press control shift. Enter.
And now we have gotten
array in horizontal form.
So this mistake was actually
here to teach you that when you were working with the race? You don't forget to press control. Shift, enter.
This is why we got this wrong result of the first place.
And this concludes the lesson about functions. Of course, there are other look of functions, but at this point, I don't think they belong at this level off course.