I am trying to find a way to return the cell address for a given value in a range (multiple rows and columns).
For example, in the range A1:D5 are numbers 1 to 20, not in any particular order and no duplicate values.
15,5,1,11
14,16,4,2
13,6,20,18
9,3,12,8
10,19,7,17
I want (preferably a formula) to return the address of the cell that contains a given number (e.g. 12 would return C4 or 17 would return D5).
Is it possible?
Bookmarks