Row Number of a String in an array of cells

Anu · 04/21/22

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?

James Keuning · 04/21/22

Use MATCH. One column with a MATCH formula for each of your email columns.

Anu · 04/22/22

Thanks James. Am doing that, but after some time it says too many cross link references and errors out

James Keuning · 04/22/22

Try to concatenate all of the columns together using + and then use FIND against that one column. It’s a stretch but worth a try.

Answers