Hello I have a worksheet where project details are inserted. The values in Column P are from a drop down list that is stored in a table in another worksheet. i defined that table as a Name_Range.
what I want to accomplish is the following. if the value in column P selected is "chief" then column O should return the value "yes" otherwise return "no". But if in column P another cell is selected as chief then an error message stating "there can only be on chief in the project".
How can I do this? please see attached a screen shot of the worksheet.
Many thanks
excel picture.png
Bookmarks