Dear Lynda

Try the below and feedback

=IF(B3=2,LOOKUP(C3,{0,2,3,4,5,6},{"","CTOD","ICTDD ","ICTOD","OCIO",""}),"")


If this post helps click Yes
---------------
Jacob Skaria


"Lynda" wrote:

I was hoping someone might be able to help me with a better formula or a code
that will give me a result based on the formula below as it comes back saying
I have entered to many arguments.
=IF(B3=2, C3=2,"CTOD",IF(B3=2, C3=3,"ICTDD",IF(B3=2, C3=4,"ICTOD",IF(B3=2,
C3=5,"OCIO"))))
with the result appearing in cell D2.
Thanks in advance.
Cheers
Lynda