What I want to do is in the attached Excel worksheet. i provide data to a call centre. The data is exported from our asset management system.
The data fields output from the asset management system are \
Pno, Project and ProjectType. I use formulae to populate the subsequent fields.
All projects which are specific types. CCTV is usually allocated to a specific subcontractor P&D. One project is not a CCTV project but needs to be handled similarly - p2043j. It was easy when this project was to be allocated to the P&D rota, I just used a formulae with an OR to make it a ProjectNote CCTV type.
Now P4043J it has to be handled by another subcontractor and another project P2186C has also to be handled by a different subcontractor.
So I want to set up a formula to set conditions based on specific project numbers (Pno) and Project Types to output the correct result to the Project Note.
Do I use IFs nested or is there another way I can do this?
I attach the data. It's my first time on this forum so excuse me if I am not supplying enough information.
Bookmarks