I'm looking for a search function to return the row and column of a cell containing matched data, or a combination of worksheet functions to do the same thing.
set up numbers 1 to 12 across B1 to M1, and in A2 down to A13.
enter formula in B2 to M13 to multiply the number in row 1 by the number in column A.
Now I have a range B2:M13 containing all the various multiples.
A countif function tells me that there are 6 appearances of the number 12 in this range.
I want to be able to find the column and row numbers (actually the numbers from the top row and the left column), where these 12s appear so I can use the values in further calculations.
The Find & Select engine returns the cells using the Find All, but I want to be able to search over the range with a function.
As there is more than one match, either returning the first one or being able to add a 1st, 2nd, 3rd etc parameter would be nice.
Is there any worksheet function to search over a range of cells?