Search code examples
if-statementgoogle-sheetsconcatenationgoogle-sheets-formula

Check many cells for data and report data if found

I'm trying to get a formula that can search through many cells for data and report the data of that cell back

eks: J2() M2(Cake) R2() X2()

Is there an easy way to "loop" or search through these and to check if there is data?

Kinda like =If(J2,M2,R2,X2, print value) would be 'Cake'

Solution

  • try something simple:

    =TRIM(J2&M2&R2&X2)