I have a file in one column we have Make and in the other column we have Model.
on a seperate work sheet there is a list of makes and models. in the make
column when you click on it there is a drop down list of all the makes on the
second work sheet and in the model column there is a drop down list of all
the models that corrospond to the selected make. now i have a 3rd file that i
am importing data makes and models into the make and model columns. But some
how i need to make sure that the makes and models that are being imported are
spelled the same as the ones in the drop down list. for example in the drop
down list there is Mercedes but in the import list it is Mercedes-Benz. is
there a formula i can run in a seperate column that will tell me yes or no if
they match up. so i don't have to go through each one individually?

=isnumber(match(a1,sheet2!a:a,0))

will tell you (TRUE) if the value in A1 is in the list in sheet2, column A.



jason2444 wrote:

I have a file in one column we have Make and in the other column we have Model.
on a seperate work sheet there is a list of makes and models. in the make
column when you click on it there is a drop down list of all the makes on the
second work sheet and in the model column there is a drop down list of all
the models that corrospond to the selected make. now i have a 3rd file that i
am importing data makes and models into the make and model columns. But some
how i need to make sure that the makes and models that are being imported are
spelled the same as the ones in the drop down list. for example in the drop
down list there is Mercedes but in the import list it is Mercedes-Benz. is
there a formula i can run in a seperate column that will tell me yes or no if
they match up. so i don't have to go through each one individually?

--

Dave Peterson

"Dave Peterson" wrote:

=isnumber(match(a1,sheet2!a:a,0))

will tell you (TRUE) if the value in A1 is in the list in sheet2, column A.



jason2444 wrote:

I have a file in one column we have Make and in the other column we have Model.
on a seperate work sheet there is a list of makes and models. in the make
column when you click on it there is a drop down list of all the makes on the
second work sheet and in the model column there is a drop down list of all
the models that corrospond to the selected make. now i have a 3rd file that i
am importing data makes and models into the make and model columns. But some
how i need to make sure that the makes and models that are being imported are
spelled the same as the ones in the drop down list. for example in the drop
down list there is Mercedes but in the import list it is Mercedes-Benz. is
there a formula i can run in a seperate column that will tell me yes or no if
they match up. so i don't have to go through each one individually?

--

Dave Peterson
Thanks that was a big help. maybe you can help me with one more thing.
=ISNUMBER(MATCH(C2,'[sheet2]Data list'!A:A,0))
this is the modification i made and this is working. but if i wanted to
check multiple columns in the second sheet how would i do that. A:A is for
checking column A but what it i wanted to check all of columns A through BK
any idea?

=match() wants to look at a single column or a single row.

Maybe you could use:
=countif('[sheet2]Data list'!A:bk,A1)0

To find out if A1 appears anywhere in A:Bk of that other worksheet.



jason2444 wrote:

"Dave Peterson" wrote:

=isnumber(match(a1,sheet2!a:a,0))

will tell you (TRUE) if the value in A1 is in the list in sheet2, column A.



jason2444 wrote:

I have a file in one column we have Make and in the other column we have Model.
on a seperate work sheet there is a list of makes and models. in the make
column when you click on it there is a drop down list of all the makes on the
second work sheet and in the model column there is a drop down list of all
the models that corrospond to the selected make. now i have a 3rd file that i
am importing data makes and models into the make and model columns. But some
how i need to make sure that the makes and models that are being imported are
spelled the same as the ones in the drop down list. for example in the drop
down list there is Mercedes but in the import list it is Mercedes-Benz. is
there a formula i can run in a seperate column that will tell me yes or no if
they match up. so i don't have to go through each one individually?

--

Dave Peterson
Thanks that was a big help. maybe you can help me with one more thing.
=ISNUMBER(MATCH(C2,'[sheet2]Data list'!A:A,0))
this is the modification i made and this is working. but if i wanted to
check multiple columns in the second sheet how would i do that. A:A is for
checking column A but what it i wanted to check all of columns A through BK
any idea?

--

Dave Peterson