My recommendation would be to use a VLOOKUP formula. First
you must create a table that maps a name to each Material
group, something like (on Sheet2):

A B
1 FI1 NAME1
2 FI2 NAME1
3 FM1 NAME1
4 FX5 NAME2
5 FX6 NAME2
6 FXC NAME2

Then use:

=VLOOKUP(A1,Sheet2!A:B,2,0)

HTH
Jason
Atlanta, GA


-----Original Message-----
Hello,
I have Column C that contains about 110 different
material
groups EX, BC1,FF1,FF3,FD1, ext upto 110. I want to
create
a formula in B, which this is Sample:
=IF(OR(C:C="FI1",C:C="FI2",C:C="FM1"),"NAME1",IF( OR
(C:C="FX5",C:C="FX6",C:C="FXC",C:C="FXR"),"NAME2" ,IF(OR
(C:C="FV1"),"NAME3",IF(OR(C:C="BC3",C:C="FV5"),"N AME4"))))
It works fine but when I add more IF(OR i get an error.
I'm able to have just 7-8 IF(OR so is this the Max in a
Cell?
I think I need about 24 IF(OR . The file that I open
might not include all groups, but changes. So my data
file
might contain some groups this month but not all. So when
I do the formula, I want to be able to look for all
groups.
Any help would be very greateful.
Thanks,
JUAN
.