Finding specific cell with respect to column.

[parthya_kadam]

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.

[#2 · Accepted solution]

@parthya_kadam 

=INDEX(AN:AN, MATCH(MIN(AQ:AQ), AQ:AQ, 0))

[#3]

Thank you so much for your reply it works perfectly well just as I wanted. Thanks again.