Help comparing values in two columns and displaying the value in another column

[rosscortb]

Hello

I am trying to compare values in two columns and return the value in another. What I have so far works however, in column O there is already the value "Trainee" which means its returning the value "Trainee Manual" even when it does not match Babcock - Weekly. Sure I need an Or in there but not very good at them.

Please Login or Register  to view this content.

Thanks

Ross

[Kaper]

Check if that works as desired:

Please Login or Register  to view this content.

[Arkadi]

Hi rosscortb,

Does this do what you expect?

Please Login or Register  to view this content.

[rosscortb]

Thanks Arkadi, your one worked perfectly, thanks again