vendredi 28 février 2020

Google sheets forumla question(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'

Aucun commentaire:

Enregistrer un commentaire