Forum Discussion
Solved
Finding specific cell with respect to column.
Hello. I wanted to find the smallest number in a column and then find the specific cell in the row of that smallest number. I wanted to know the formula using which I can do mentioned above.
In photo mentioned below, I want to find smallest number from Column 'AQ' and find the number which is present in Column 'AN' with respect to that smallest number.
=INDEX(AN:AN, MATCH(MIN(AQ:AQ), AQ:AQ, 0))
2 Replies
=INDEX(AN:AN, MATCH(MIN(AQ:AQ), AQ:AQ, 0))
Thank you so much for your reply it works perfectly well just as I wanted. Thanks again.
