G
Guest
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?
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?