Excel lookup in multiple column array, return row

Question

I need to lookup the value of something in a table and then return the row that it's in. The value can be in any column, so Match doesn't seem ideal. What's the best way to do this?

As an example, say the table has 2 columns. Column 1 has A, B, C, D. Column 2 has E, F, G, H. I want to find out which row "G" is in, so I want to somehow return "3" without knowing beforehand that "G" is in column 2.

Answer 1

Please try:

=IFERROR(MATCH("g",A:A,0),MATCH("g",B:B,0))  

and so on if more columns.