ashfire jon
New Member
Hi all, i tried using this formula at work but couldnt get it to work and was intersted in what you guys would suggest.
I got a work around using normal IF over 5 columns.
Long term solution is to get it back in Access, which isnt my job
.
=IF(F2=OR("AEC","DDH","externals","fec","quality","test & trials","unit 1","unit 1&2","unit 2","unit 3","unit 4","unit 5","unit 6","unit 6&7","unit 7","unit 8","unit amn","unit dgm","unit ferm","unit mrm","unit rtm"),"Construction",IF(F2=OR("electrical w/shop","ms","nbf","paint","plate prep shop","pmf","pps","","sms"),"Manufacturing",IF(F2=OR("nas","nas-annex","nas-outfit"),"Fabrication",IF(F2=OR("none budget","purchase part"),"Other","Another"))))
Thanks
I got a work around using normal IF over 5 columns.
Long term solution is to get it back in Access, which isnt my job
=IF(F2=OR("AEC","DDH","externals","fec","quality","test & trials","unit 1","unit 1&2","unit 2","unit 3","unit 4","unit 5","unit 6","unit 6&7","unit 7","unit 8","unit amn","unit dgm","unit ferm","unit mrm","unit rtm"),"Construction",IF(F2=OR("electrical w/shop","ms","nbf","paint","plate prep shop","pmf","pps","","sms"),"Manufacturing",IF(F2=OR("nas","nas-annex","nas-outfit"),"Fabrication",IF(F2=OR("none budget","purchase part"),"Other","Another"))))
Thanks