If you have the actual defect codes in a list with the abbreviation in the 1st
column and the code in the 2nd, and you've named that range CodeTable

=IF(ISNA(VLOOKUP(A1,CodeTable,2,0)),
"Not A Defect Code!",VLOOKUP(A1,CodeTable,2,0))

all on one line, of course.

On Sun, 26 Sep 2004 22:16:16 -0500, drewd
wrote:


--------------------------------------------------------------------------------

What I need to replace the cells that have 2-3 letters is:
"Not A Defect Code!!!"
I have a sheet that has many different defect codes such as:
MC
WP
MPI,ect,ect
All of these will be change to the defect code they represent.
I could not figure out how to change a defect code that was improperly
entered in such as:
"FC": to "Not A Defect Code!!!"

thank you for the help
Drew