Hi,
I'm trying to create a formula that checks column A for a value (e.g. "Alpha") and then checks column B ("Status") to return a value based on a certain order. In this example the order should be Red, Amber, Green and finally Completed.
For example, if any of the values "Alpha" in column A has a corresponding "Red" value in column B, the overall status should be "Red". I no "Red" value exists, it should check for Amber, then Green and finally Completed.
Any ideas?
Bookmarks