Google-sheets – Formula for getting the Left most cell value from a ‘Range of cells’

formulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-queryregexextract

Need your support in finding a solution for an issue which I am facing now.

enter image description here

Formula for Column A… Data Range from B to D

  • Have values in a range of spreadsheet cells (From column B to D)

  • Value may or may not be present within the range

  • I need the formula to update the leftmost value from the same row to the Column A.. E.g In Row 2, "Abil" is the leftmost cell from the range B2 to D2.

Something like =Left(B2:D2) which will select the leftmost cell value to the A2 cell

Best Answer

=ARRAYFORMULA(IF(IF(B2:B<>"", B2:B, C2:C)<>"", 
                 IF(B2:B<>"", B2:B, C2:C), D2:D))

0

Related Topic