Or, put your test code list in another column maybe on another tab, and do a vlookup:
=if(isna(vlookup(B1,Codes!A$1:A$99,1,0)),0,1) Phil. -- Don't you just hate self-referential sigs? -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted