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

Hi Karen,

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

HTH

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))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karen" wrote in message
...
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

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.

--
Biff
Microsoft Excel MVP


"Karen" wrote in message
...
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