Assistance with IF / AND / OR

[Just_Pat]

Hello everyone and thank you in advance for looking at my problem. Truth be told I've been circling this problem enough that i don't even know if i'm on the right track anymore.

here goes. I am building a report to determine where a ticket is assigned so that if it requires an update the correct manager can be notified. I have 3 columns with various names and groups and i need to return 1 of them depending on the content of the other 2.

Here is a sample:

Current Analyst	Current Group	Forwarded to	Assignee (expected result)
Elaine	Nayan	Corporate Systems Admin	Corporate Systems Admin
Joyce	Urmil	IT Officer	Urmil
Segun	(Security)	Unspecified	(Security)
Patrick		Service Desk	Service Desk
Eric		IT Officer	Eric

here is what i need:
If "Forwarded to" is IT Officer or Unspecified i need it to return "Current Group"
If "Current Group" is blank then i need it to return "Current Analyst"
If none of the above is true it should return "Forwarded to"

it seemed so simple when i first started with the formula but each thing i tried just made it more and more complicated.
If anyone is willing to help it would be greatly appreciated

 

[JoeMo]

In D2 and copy down: =IF(B2="",A2,IF(OR(C2="IT Officer",C2 = "Unspecified"),B2,C2))

 

[DanteAmor]

How about:

Dante Amor
	A	B	C	D
1	Current Analyst	Current Group	Forwarded to	Assignee (expected result)
2	Elaine	Nayan	Corporate Systems Admin	Corporate Systems Admin
3	Joyce	Urmil	IT Officer	Urmil
4	Segun	(Security)	Unspecified	(Security)
5	Patrick		Service Desk	Service Desk
6	Eric		IT Officer	Eric
Hoja6

Cell Formulas
Range	Formula
D2:D6	D2	=IF(OR(C2={"IT Officer","Unspecified"}),IF(B2="",A2,B2),C2)

 

[Just_Pat]

that's exactly it!
Thank you very much

 

[DanteAmor]

Glad we could help & thanks for the feedback