"IF" Formula

  • Thread starter Thread starter Karen
  • Start date Start date
K

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
 
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))
 
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.
 
Back
Top