Row Number of a String in an array of cells

Columns G to M have email ids in several rows.

I want to look up a specific email in columns G to M and find the row number.

Is it possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!