This would probably be better implemented as a custom VBA function or using
a lookup table.
Create a table using the last 3 characters of the part numbers (although it
looks like in some places you're using only 2) and use vlookup against that
table.

Tim



"beechum1" wrote in
message ...

so here's the function.....

=if(RIGHT(B1,2)="11","J",if(RIGHT(B1,2)="12","J",i f(RIGHT(B1,)="13","J",
if(b1=id021,"a",if(b1=xd021,"A",if(RIGHT(B1,2)="20 ","b",,if(RIGHT(B1,2)=
"21","B",",if(RIGHT(B1,2)="22","B",if(b1="ib031"," D",if(b1="id054,"D",if(b1=
"me031","d",if(b1="mb031,"D",if(b1="yb031,"D",if(b 1="yc031,"D",if(b1="xd031,
"D",if(b1="xc031,"D",if(RIGHT(B1,3)="031","E",if(R IGHT(B1,3)="032","E",
if(RIGHT(B1,3)="041","E",if(RIGHT(B1,3)="042","E", if(RIGHT(B1,3)="051",
"C",if(b1=db052,"g",if(RIGHT(B1,3)="053","c",if(RI GHT(B1,3)="054","D",if
(b1=db055,"g",if(RIGHT(B1,3)="061","E",if(RIGHT(B1 ,3)="062","E",if(RIGHT
(B1,3)="071","E",if(RIGHT(B1,3)="072","e",if(RIGHT (B1,3)="080","I",if(RIGHT
(B1,3)="081","I",if(RIGHT(B1,3)="082","I",if(RIGHT (B1,3)="083","I",if(RIGHT
(B1,3)="084","I",if(RIGHT(B1,3)="085","I",if(RIGHT (B1,3)="086","I",if(RIGHT
(B1,3)="087","I",if(RIGHT(B1,3)="088",if(b1=db122" ,"B",if(RIGHT(B1,3)="121",
"a",if(RIGHT(B1,3)="123","A",if(RIGHT(B1,3)="221", "B",if(RIGHT(B1,1)="l","N",
if(RIGHT(B1,1)="r","n",if(b1="hd981","I",if(b1="id 981","I",if(RIGHT(B1,3)=
"081","G"))))))))))))))))))))))))))))))))))))))))) ))))))

the value in B1, will be any of the following and more.....
HB011,HB021,HB031
HB041,HB051 something like that..... we have about 300 part numbers
that i have to be able to use the last 3 characters to know what part
CODES they are. the first two letters indicate the year and model, and
the last three numbers indicate which part, and for what application. it
appears however that a cell can only hold 255 charachters or so and i
can't fit my function in there.

if not the function, or some code, how can i get all this done?


--
beechum1
------------------------------------------------------------------------
beechum1's Profile:
http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=501427