This is simpler

=IF(B2<"";"I",IF(C2<"";"C",IF(D2<"";"S";"")))

or even

=CHOOSE(MATCH(A2;B2:D2;0);"I";"C";"S")

--
__________________________________
HTH

Bob

"Alexandra Lopes" wrote in message
...
Bob Phillips wrote:
I am not going to open an attachment, but from your follow-up post, I
think my previous formula is exactly what you want.


Hi again!

To solve my problem i'm using this formula:

=IF(B9=VLOOKUP(B9;$AE$9:$AE$40;1;0);"S";IF(B9=VLOO KUP(B9;$AC$9:$AC$40;1;0);"I";IF(B9=VLOOKUP(B9;$AD$ 9:$AD$40;1;0);"C";0)))

But i have a new problem, that is: when i have a result N/A in one of the
cells, the result it's N/A, and not the real result that i expect.

Can you help me please?

Thanks

Alexandra