we are going to discuss the match
function the match function is useful
when you have for example we have
existing existing account numbers and I
have about 400 or 500  of them  in this list
and then I have new numbers and I you
want let's say you want to check to see
if these numbers are you existed so
you'd go equals match open bracket and
then you would match the number here
which is B2 put a comma and then
you're gonna match from the whole list
so all we needed was we're going to
click on the first cell here and we're
gonna press Ctrl Shift down arrow to get
to the bottom of the list
okay and then we're gonna put in another
common here and we're gonna put in 0 for an
exact match and then scroll back up the
top and then we'll press Enter
so we returned in a and so it's double
click that down and so the ones that it
does find it returns the relative
position that it is in the list next to
it now what they're talking about here
is so it returns 498 appears relative to
24 so this one is we have our title in
the first line so this is an count 4
and plus the 24 then if we scroll down
to line 28 there we find our 498
certainly interesting but it's difficult
to work with
so let's just have a less whether the
match actually exists so let's go back
into our formula and let's go put an iF
in front of this and what we're going to
do is we're gonna say if it's this is a
number then you
return yes and if it's not a number of
 return no so let's go
in front of our match let's go if and
then I am going to go isnumber and then I'm gonna put another
going to say yes and false it  says no so
we will close our brackets and see what it says
so it says no so lets click on that and then we will click on
 
the fill handle here and so there by
putting his number and if function
around it it makes it a little more
useful least tells you definitely
whether there is a match and the other
the other range of this number so there
you have match function please subscribe
