columns_if

[Alexandra Lopes]

Hello,

I have a column with names. In 3 columns to follow, I have these names
distributed for the 3 columns: Bad, Mediums and Good.

I intend that in one another column appears I - if the name is in the
column Bad, C - if the the name is in column Mediums and S - if the name
is in the column Good.

Thanks in advance!

 

[Bob Phillips]

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

 

[Alexandra Lopes]

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

No.


What I want is the following one:
I have the data of the columns A, B, C and D and want that through a
function to get the data of the column E, having in account the
conditions that I related previously:

I - if the name is in the column B, C - if the the name is in column C
and S - if the nameis in the column D.



Example:

A B C D E

Name Bad Medium Good Groupe

Ana Ana S
Maria Maria S
João João S
Pedro Pedro C
António António C
Marco Marco C
Filipa Filipa C
Nuno Nuno I
Mario Mario I
Vasco vasco I

 

[Bob Phillips]

I am not going to open an attachment, but from your follow-up post, I think
my previous formula is exactly what you want.

 

[Alexandra Lopes]

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=VLOOKUP(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

 

[Bob Phillips]

This is simpler

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

or even

=CHOOSE(MATCH(A2;B22;0);"I";"C";"S")

 

[Alexandra Lopes]

This is simpler

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

or even

=CHOOSE(MATCH(A2;B22;0);"I";"C";"S")

This results!

Thank you very much!

 

[Bob Phillips]

It was my use of commas that was the problem, your Excel requires
semi-colons as separators.