SOLVED

Finding specific cell with respect to column.

%3CLINGO-SUB%20id%3D%22lingo-sub-1573764%22%20slang%3D%22en-US%22%3EFinding%20specific%20cell%20with%20respect%20to%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573764%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20wanted%20to%20find%20the%20smallest%20number%20in%20a%20column%20and%20then%20find%20the%20specific%20cell%20in%20the%20row%20of%20that%20smallest%20number.%20I%20wanted%20to%20know%20the%20formula%20using%20which%20I%20can%20do%20mentioned%20above.%3C%2FP%3E%3CP%3EIn%20photo%20mentioned%20below%2C%20I%20want%20to%20find%20smallest%20number%20from%20Column%20'AQ'%20and%20find%20the%20number%20which%20is%20present%20in%20Column%20'AN'%20with%20respect%20to%20that%20smallest%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573783%22%20slang%3D%22en-US%22%3ERe%3A%20Finding%20specific%20cell%20with%20respect%20to%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752978%22%20target%3D%22_blank%22%3E%40parthya_kadam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DINDEX(AN%3AAN%2C%20MATCH(MIN(AQ%3AAQ)%2C%20AQ%3AAQ%2C%200))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576377%22%20slang%3D%22en-US%22%3ERe%3A%20Finding%20specific%20cell%20with%20respect%20to%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576377%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%20for%20your%20reply%20it%20works%20perfectly%20well%20just%20as%20I%20wanted.%20Thanks%20again.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
Best Response confirmed by parthya_kadam (New Contributor)
Solution

@parthya_kadam 

=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.