Hi,

I am working on a sheet to direct instructions based on set criteria -

E.g.

Do the comments say:

Bee's if the Locations is...Regional or Metro or BY/BU/MJ then = Regional should be "Raise Work Order 45-Type $$$$ before adding comment". if the Location is...Metro then say "Raise Work Order 45-Click on Down Arrow on CREW-MET and lastly if the cells say BY/BU/ML then say "Raise Work Order 45-Type $$$$ before adding comment".

This is the formula I have so far:
=IF(OR(C4="Metro",C4="Regional",C4="BY/BU/MJ"),("Raise WorkSlip 45 - Type $$$$ before adding comment",and("Raise WorkSlip 45 - Click on Down Arrow on CREW: Choose MET ")),"Raise Workslip 45 - Type $$$$ before adding comment")

Obviously it is not working. It may not even be the best formula function to use but open to suggesttions. All I want is it to do this -
If this cell says this... then I want it to say this......
3 times over because there are only ever 3 locations with different actions to follow.

see attached - :Metering Services Projection Assistant v1.xlsm


Please help.....beginner advance user :-)


P.S I have attached my spreadsheet if it helps.