All language subtitles for 1. LOOKUP Functions

In this video we will learn about look up and the defense functions in excel.

We use these formulas to set a data table or array for specific values.

Select the cell where you want to use it.

Then on the formula step in the function library click look up and reference.

And from the dropdown list select the function you want to have the most popular functions on it look

up and we look up the to look up function.

Looks a lot of value in the top row of a data set once it finds it.

It travels down in the same column and it turns a value from the row that you specify in the function.

For example in our dataset the top row has cities salespersons sales and sales rank let us get to look

at function to find the name of salesperson in the fourth row to do that.

Select the cell and on formulas type in the function library look up an inference function

select to look up in the function arguments dialog box you can see there therefore arguments that this

function takes that first is a lookup value then lookup value is the value that we are going to search

for in the top row of the dataset is we are going to look for salesperson we wanted this formula to

find a column which I salesperson.

So let us enter salesperson here or the refers to a sale which has the salesperson value the table that

it is the array of values you want the function to search let us select the data set that we have put

these nine the raw index number tells from Wichita.

This function so the value let us into full because we want to return the sales person name from a for

finally the range lookup argument tells Excel whether it should look for exact match for the lookup

value or an approximate match in this case we want an exact match by default it look at function and

we look at function both look for approximate match set the range lookup argument 2 0 are false

what we are telling Excel is use to look at function to find the value which is the insulator Dean in

the top row of the deterrent A1 would be 9 and when it does that it will find salesperson value in 813

and then it'll go in the top row of this data ring and find salesperson in column B

and then we are telling Excel to move down to the fourth row and return the value from the fourth row

so the function will go down to the fourth row and return the value others let us click OK and you can

see it dozen others

that are popular look at function is v look up the V lookup function works on the column just like you

look up looks for a value in the role that we look at function.

Looks for a value in the first column of the data set.

Let doesn't really look a function and do the so it's great area.

Now let us do as we look at function to find a salesperson for Jenny so let us enter Jenny here and

then sell B2B will enter the V lookup function.

So let's do that select the relook at function.

You can see in the function arguments dialog box that it uses exactly the similar arguments as to look

up the first thing is look at value.

In this case we wanted to look for lookup value.

Ken name it is in cell 813 that table array is the same one today name in it to look up we specified

the role from it it should return the name of the salesperson in we look up we'll specify that column

number from there.

The formula needs fruit and the value since the salesperson name is in column 2 let us enter to the

column index number and let us again set the range look up as 0 meaning we are looking for an exact

match.

Now what will happen when we execute this formula is accelerate look and cell 13 accelerate looking

then 813 find the value to know that then they'll go to the data and have specified a one to these nine

this is the first column start looking in column me for value tonight it'll find tonight in the row

for and then it will travel to the right to the second column which is a salesperson and on the intersection

of 0 4 and column 2 it find a value others and will return others.

So let's look.

Okay and you can see it there done others.