My goal is to return two potential values depending on what is selected in a multi-select column (Named: [VA...DBQ Worksheet] ).
The dropdowns are:
Service Connected Diagnosis Blank
Service Connected Diagnosis Incomplete (Rated as vs. Contention Name)
If any of the first three are selected I want the result to return as "Miss". If the ICD Code dropdown is the only thing selected, I want it to return "On Target". If nothing is selected, just return blank.
I'm thinking it would be some form of a nested IF and OR formula? My brain is stuck.
Help Article Resources
Check out the Formula Handbook template!