Forum Discussion
Return non related value based on one, two or three cells
Cells A2:C2: are populated with text. How can I return a value to D2, that is determined by different combinations of A2:C2? Based only on whether or not A2:C2 values contain text or are empty. D2 wo...
=MAP(A2:A7,B2:B7,C2:C7,LAMBDA(colA,colB,colC,IFS(AND(ISTEXT(colA),ISTEXT(colB),ISTEXT(colC)),"x",AND(ISTEXT(colA),NOT(ISTEXT(colB)),ISTEXT(colC)),"y",AND(NOT(ISTEXT(colA)),NOT(ISTEXT(colB)),ISTEXT(colC)),"z",TRUE,"")))
Maybe you can apply this formula with Office 365 or Excel for the web alternatively.