Clever Geek Handbook

How can I get a reference to a cell in an array knowing only its value?

I have an array of columns with the following values ​​in my sheet: 11, 15, 5, 7, 2. I want to get a reference to a cell that contains the value 15. How do I do this?

thank

0


source to share


1 answer


If your array is A2: A13, here is the formula that will give you a cell reference with the value 15 ...



INDEX (A2: A13, MATCH (15, A2: A13))

+2


source






More articles:


All Articles