Formula that returns row number and column number

Hi all,

I am hoping to find a formula that essentially does the opposite of an index formula. I have a table of numbers with 10 rows and 10 columns. Let's say the intersection of row 4 and column 3 has the value 14. Is there a formula that can look up the value 14 and tell me that the row is 4 and the column is 3?

Goal: As mentioned above, I have a table of numbers with 10 rows and 10 columns. I also have a list of numbers. I want to see which numbers from my list are found in the table of numbers.

I know how to do this using MATCH, but that function can only be used if you have 1 row and x columns or x rows and 1 column.

Thanks for everyone's help.

Row ...

=SUMPRODUCT((A1:J10=14)*(ROW(A1:J10)))

Column ...

=SUMPRODUCT(($A$1:$J$10=14)*(COLUMN($A$1:$J$10)))

If value(s) are unique

Thank you very much.

Can you please explain how the formula works though?