hello and welcome to our new video
in this video we are going to learn
about index formula
now what does index formula do?
we have seen vlookup in one of our previous videos
what does vlookup do?
if i want to know
about a person's
salary
or
city
or age
then i can use vlookup
but in vlookup
there was a small shortcoming
that if you want to know
the data of a column
then you can't do it
for example, let me show you
that i have some data
if i put vlookup in that data
then what was that thing
which i couldn't get
but if i use index formula
instead of that
then i get that thing
so first of all let me open excel
and here you will see
some employees data
serial number
20 employees
employees id
employees name, age
address and salary
if i want to know
that in which city
jishan lives then i can find out
he lives in palwal
now we can find this thing
with the help of vlookup
or with the help of index
but if i tell you
that tell me the employee id of imran
you can't find this
with the help of vlookup
what we have to do
we have to use index formula
now how this index formula works
let's see
so first of all
i have to find out
the data of deepak
it can be the data of the column
in the back or in the front
so first of all
you have to put an equal sign
and for the formula
you have to write index
now it is suggested to you
you have to double click
now it is asking us
which array you want to choose
array means array table
as we have seen earlier
we select the whole table of array
so what we have to do
we have to select the whole table
like i have selected the whole table
after that it is asking me
row
in the formula of vlookup
we used to put column number
here also we have to put column number
but here we have to put row number
there is a benefit of this
like how you have to find
the row number
like you have to find
shivam's id
so for shivam's id i have to see the row number
and i will never count the row number from here
1,2,3,4,5
i will leave this heading
i will count from here
where my name is written
1,2,3,4
i got to know that in which row shivam is
shivam's data is in 4th row
so what i will put here
i will put 4
apart from this i have to put column
i have to put column number
now how i will put column number
if i have to find the age
then i have to count from here
as we have seen earlier
that my column A
i will put number 1
for D i will put number 3
for D i will put number 4,5,6
if i have to find
that in which city
shivam lives
so for this you have to count
1,2,3,4,5
where is the address column
so i have to put column number
5
i entered 5
so i got Delhi
i got to know that where shivam lives
now we got to know this
apart from this what you can do
suppose that we have to find
shivam's salary
to find salary what you will change
now you will change
my column number
here 5 is written
what you have to do
6
enter
type mistake
remember this
double bracket
here is open bracket
here is closed bracket
but here is one more bracket
so this is correct
as i suggested
so this is correct
so shivam's salary is also
40,000
apart from this what we can do
suppose i have to find another row's data
so what we have to do
we have to change row's number
suppose i have to find
neeraj's age
row number is 8
so here i will type 8
and i will count
in which column my age is
1,2,3,4
so here instead of 6
i will write 4
after writing 4 i entered
so i got to know that neeraj's age is
32
so far he has done the same
as our vlookup formula
but here is one thing
suppose i have to find employee's id
to find employee's id
vlookup doesn't give us any provision
that you can find
so what we have to do
here we have to use index
as i do here
here
in column number
which column is this
column is 2
so we have to find neeraj's employee id
so here i wrote 2
after writing 2
i got to know that neeraj's employee id
is 1989
now why this index formula
is taking rows and columns
what it does
suppose i took 8th row
after taking 8th row
it took column
so it works like this
it will find in this row
which column number i have to stop
as we have told that i have to stop at 2nd column number
so it worked like this
and came here
so which cell will be selected
it will be selected 1989
so in output it will show
1989
in this way you can find other
i hope you understood
how to use index formula
if you still have any doubt
then watch this video again
and
i will meet you in next video
till then keep practicing