"IF" Formula

[Karen]

I need help with a formula (not necessarily "IF") which will help me display
the following results:

Analyst Remarks
A ON PROBATION
B
A ON PROBATION
D
C ON PROBATION
B
B
D
E EDITOR
F
G TEAM LEAD
F
E EDITOR
G TEAM LEAD
G TEAM LEAD

I would like to have a formula in the "Remarks" column where if it detects A
in the "Analyst" column, ON PROBATION will appear. If the "Analyst" column
shows G, TEAM LEAD will appear. Similarly, if "Analyst" column is E,
"Remarks" column will show EDITOR.

Thanks,
Karen

 

[Carim]

Hi Karen,

Press F1 for help, and take a look at vlookup() formula ...

HTH

 

[Max]

Place in B2, copy down:
=IF(ISNA(MATCH(A2,{"A";"E";"G"},0)),"",VLOOKUP(A2,{"A","ON
PROBATION";"E","EDITOR";"G","TEAM LEAD"},2,0))

 

[T. Valko]

If you only have a "few" variables then you can use an IF formula:

=IF(A2="A","ON PROBATION",IF(A2="E","EDITOR",IF(A2="G","TEAM LEAD","")))

Copy down as needed.

If you have more than a "few" variables then you should create a 2 column
table like this:

...........AA.................AB..............
1.......A...........ON PROBATION
2.......E...........EDITOR
3.......G..........TEAM LEAD
4.......B..........XXX
5.......F..........YYY

Then you could use a lookup formula:

=VLOOUP(A2,AA$1:AB$5,2,0)

Copy down as needed.