a local taxes 2013 chat rooms in this
video only showing you how to use T ends at function
along deal function and
so ish wanna play along falling view to don a 6-2 upside down in Texas 2013 TV
59
nation on a okay
side I am in order to understand the
ends it function you can eat understand the deal function
festival
and context what we're trying to do you can try to create
closed at should form she's here
and Gannett's in text boxes here we're going to look up
values in the a table
and table working looking up values in is this will take
was clearly she clearly bookings explode making also questioned this query
for example on the 10th October
in room two one the stair record
soldiers gonna look for tent October
here may have it's not gonna look if it isn't
signed as well and it's going to look for
from numbers were always look for the reminder specifically
Marshall my t-shirt one inside to use
facts number one and each
if finds a record is gonna return
guest here if it doesn't find a record this
fees we're gonna have a problem so its festival tryin
two-year 2d function
K him safe closed at
season there you so go to
design and shoes
text books strip for textbooks in anger
label and
rename this
text 80 hours
text 0 suppose list
such three
she's text long
and text to
okie dokie right gonna be copping a functional previously safe week
on going to be tricky you know if
format every time we get a data to come here
first equals Andy
an opportunist looking up guest Inc revoking exploded wherever mighty
who's from it. and the day
&gt whose converting
day plus and 0 de makes some sense
known sure from too many
closing back use this is one 40 star Swan
to use
Surrey to one
Journal Sr but the press OK see what happens
that's interesting
which is actually returning to correct name in certain instances
as expected to return an error only returns an error if you doing
must be 2013 it on something other era us to the new
change rid of okay learn something new everyday
okay first less them make
just texted smaller so you want something condensed
be nice
Twitter
from okay to go to pick up two things
festival one Minister designed you
coat to you she's creep expert a good guest
and went over to do first time in the last thing
left take a guess first name common one
so it's gonna be returned in the first letter VTI lost nine
eisner 5
jameson
shoreline I was kinda random are traded pixels kinda hoping for massive air is
coming up here
but his deal
at the moment still kinda relevant we've got the name being returned
finds a record which it does and we've got basically no thousand
actually if it does in by
Ste knows gonna Sastre want to
value in now -1
I was kinda got due to this is the this is a video about the ends at function
centre is a day
before the delight of you type in and said
and then bracket and after up
comma -1 bracket what it does is it says
dysfunction hey which is the dealer cost function
that needs to return a value it returns no
we're gonna put this valued and the value we put in if it returns no
community -1 scored a good option Free Press okay now
you cedar unlike
some reason to use either the anytime is fine to record returns name
anytime it doesn't find a recorder returns -1
okay that's what you need to any
take this control C
gonna go to the next text books truck in there
mighty an energy
just change it 1
K
so we're going to do now is on and work my way
long the former
changes work my way along D
writing textbooks and adding
same and India
function on scanner increment this value one every single time
so much can pause the video so I can show you in done everything
sexy in two seconds Okies
have done that Paso chain
go down CNN's go as we have
missed jameson
seems to be everywhere I'm I am
yet where we've got a guest recalled
we get the name as a guest where we have my record so we get -1
nothing I could have done it which shows a guest and then
no I am fucked
I decided to do it this way breezes which will come
parent in the next video a so 10 single do actually
now go to form
and
to see data and lower additions actually
tuition
okie dokie said asap so what is the ends its function do
when used deal function to return a value if
you can't find Valley to return returns a null value which
policy previous taxes 2013 actually generate an error
there was a change that now Barack you can use and ends at
yourself anyway and decide on the value
it's been returned stay one last look at showing so ended looks up
that so dear Cup get step
values that value returns no is nothing there
which I went okay give us a -1 instead STI
necessary nothing more to say about it forbes
okay say thanks for watching a and have seen the next video
will be doing some conditional formatting