I have an excel sheet with some rows I want to evaluate that would set the value of a blank column and need help with the formula.
Column J is the column with the result
Checks in this order of override
Column J should = "" is Column L is Not Blank
Column J should = "Warning" if Column K begins with "Warning:"
Column J should = "Missing" if Column L is blank