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.
Bookmarks