Hello and welcome to our new video
In this video we are going to learn
About Match formula
What does match formula do?
Suppose you have two lists
In two lists name is same
But in first list order of names
Is different in second list
Name will be same in second list
But order is different
For example in first number
Rahul is written
In second list Rahul is written
In fourth number
This is a difficult task
I will tell you
How to make it easy
Match formula
Is a boon for data entry
In corporate office
Let's see
How to use some data
How to apply
Match formula
Here some data is given
I have two lists
Let's consider
This is first
This is second
This is serial number
Name is written
Jethalal is written
Daya is written
Babita is written
Sonu is written
Madhvi, Abdul, Komal, Goli
Name is written in order
In second list
Komal is written
Babita is written
Name is same
In first list
Jethalal is written
In second list
Komal is written
Daya is written
Babita is written
Match formula
For example
I want to find
Jethalal In which serial number
I want to find
I want serial number
I will use match formula
We will see later
How to shorten this list
In order
In second list
Let's see
Suppose I want to find Jethalal
In which serial number
You can easily find
In fourth number
But if data is large
We use excel
Suppose 1000 rows
How to find Jethalal
We use tick
Jethalal is here
Babita is here
It is not possible
In this course
We are learning
How to use excel
That's all
Here In this
We have learned
Whenever we use any formula or function
We know
How to use excel
I will increase size
And Along with this
I will
Increase Column size
So that
You can see things better
Now Match Match Match Lookup value
Jethalal Find Jethalal
Comma Comma Lookup Lookup Vlookup Vlookup Vlookup Count
Same Match
LOOKUP You can get
From O13 to O22
I selected
Comma I got the value
From here 1 0 so we have to do exact match so to do exact
match we will put 0 so either put 0 manually or double
click on it
I double clicked so it came and after that what I have to
do simple
I have to enter as soon as I entered so here you can see
what came 4 came now see 4
Jethalal in this list which number is on 4th number now
let's change it a little instead of K13
I have to find out that Babita Ji which number is on this
list if you want to know what should come on output result
should be 2 so I did Babita Ji and here I entered so it
came 2 now first thing is done second thing is I have two
list as I show you here we go to sheet number 2 and here
same thing
I removed serial number here Jethalal, Daya, Babita,
Champaglal if I want to short the order in which things are
written here so how they will do now here things are
written in 10 rows if they are written in 1000 so what I
will do
I will lose my day so if we can do it in same order so what
I will do then it will be easy for me if I have to cross
check this is easy here is Jethalal
I am checking in whole list where I will get Jethalal it is
very difficult task so here you have to do same thing match
formula you have to write eq increase it
so here you have to write eq and match double click lookup
value
lookup array
comma exact match
double click enter same thing
now we can drag it down or we can do one more thing double
click formula will be applied on all numbers now one thing
you have to take care here is hashtag now why it is here
I will tell you the problem is we did not look this list we
did not look this list and we know that it is very
important to look range when we do exact match so what you
have to do you have to select it from here after selecting
it you have to press F4 and after pressing F4 you have to
press enter now I will do it again look values came or we
can remove these values and this value came enter double
click here so it will automatically fill other values so
you have to remember when you go to
you have to lock that range otherwise it will show error it
will show error after this you will say what is the use of
this these names are same give me some time let's do some
arrangement so we have to select whole select both columns
and where we have to go we have to go to short and filters
we will go to short and filters after that here you will
get option of custom short go to custom short like this now
it is saying how to do short by so we have two options
column L and column J so what we
to do we have to do according to this so we will select
column J this column can vary but these numbers on which
column you have to put so I have put column J values and
here it is asking how to put smallest to largest like this
so if we short this so it will be short so we have done ok
and you will see on first number second third fourth wow so
what we have done we have in this list the data is short in
this list also comal is on first number babita is on second
now how easy it is for you if
have 1000 written like this so you have to see comal,
babita, beda like this not like that comal is on serial
number here it is on 5th serial number so what you have to
do after seeing comal on first number you have to see 1000
people's data so you have to see comal is on 800th number
so you have to see comal is on 800th number
If you find Babita in this list in second list then what
you have to do if it is in 666th number then you have to
see it 666 times so it is very difficult but excel made our
work easy so I think you understood how match formula works
and if you still have any doubt then play this video again
I will meet you in next video till then keep practicing