folks,

i need to use the if function but i have about 40 different choices.
i need to use the or funciton with it.

heres what i need to do:
every day new data gets imported. the value in cell A1 will be the make of a car or the model of a car so i need to fill in A2 saying wether its the make or model. i could use the code below but i have around 50 makes of cars that i have to put it. is there any way other way i could do this or can i use insert->define a range of values and could i use the if function with this range?


=IF(OR(A1="TOYOTA",A1="FORD",A1="HONDA"),"MAKE","MODEL")