I am trying to program excel for a really long conditional statement. First
column is product ( approximately 200 unique products). The second column is
for product families (10 families). I want to enter the product and
automatically populate the family column. Can I write an IF statement of this
length, and if so how? I'm hitting a wall here.

Example is: products MP-700, MP-550 and MP-600 are ABC family; i-50, i-40
and u-80 are DEF family. Any help on what this string would like is greatly
appreciated.

Thanks, Mike