I'm gonna talk about doing index match today with when you have to match either
one column or the other column the first column would be your primary column
then sometimes is the answer is in the second call so we have for example some
account numbers and that would like to grab people's last name and so what I've
done and sheet two is I have got a table here that has account numbers and the
last name now because customers are on our are entering your last name
sometimes their last name ends up in the first name
field so we'd like to search for the last name field first heard like to
search by both the last name field on the first name field to see if we have
anything that matches a customer number
the other thing too is I have named these Rangers I name the account number
in our name first name and last name used to make it easier for writing the
formula so now let's go back to our first sheet and in the field next to the
brown that we have been here
lets write our formula so we're gonna go equals index and what we're trying to
find is the account number and as you noticed that I do I have that name so
let's go A and the account number field shows up
how we're going to do and
so we can get it from the place we get it what we're gonna do it wouldn't do it
in iferror do is we're gonna match this this field and we put a comma in here with the first
name FirstName feild there and we would like it to be
exact match so we are going to enter 0 here and then we're gonna close the bracket and
then we're going to put a comma so that's if everything goes wrong so let's
go and see what it's supposed to be normally match and now I'm still matching
the same one so I'm just gonna type in the B2 with last name of the field
so lets start typing last name and once again I would like it to be an exact match and I put
a 0 and I put the closing brackets
and there is pulled the account number for Brown here and so
lets drags down and pulled all the account numbers you know if we look back
and sheet2 some of the names are in the last name field and them some of the names
are in the firstname field so this index match has used has gone between one
field in the other two back to back up with the note the account number is
there you have index match on one of the other fields and to subscribe