If statements

[Guest]

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

 

[Guest]

Hi Mike,

I would set up a lookup table on a separate sheet, where column A would be
your product and column B would be the family. Assuming you have 200
products in this table in a sheet called "Lookup", and assuming the first
product you wanted to look up was in cell A1 on your product list sheet, the
formula you would write in cell B1 on the product list sheet would be as
follows:
=IF(ISBLANK(A1),"",VLOOKUP(A1,Lookup!$A$1:$B$200,2,FALSE))

You could then copy this formula as far down the sheet as you need to go.

Hope this helps,

Mark