I am trying to come up with formula in excel for the following:
I have several columns that have the following criteria Civil Est 1 through to Civils Est 5 also Status Est 1 through to Status Est 5
In each of the Civils Est there is Completed or Not Completed or the cell is blank. In the Status Est there are a series of numbers.
What I want is if one of the Civils Est column has the statement not complete I want it to return the value from the relevant Status Est column.