in the above sheet values in A2:D6 will be either (NP, D2, D3 or OK). How to get automatically with formula to return a text in say column E2. Check cells (A2:D2) Condition1 is if any of the cell value is "NP" the value to be returned in is "NP". Condition2 if no "NP" then if there is D2 it should return D2. If none of the cells are with "NP" & "D2" if it has "D3" then return "D3". If all cells is with ÖK" then value to be returned is OK.