View Single Post
 
Old 04-19-2016, 08:50 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

If you have your data where you want to find the lowest value in C1:C20 and the data you want something returned from in A1:A20 then try the following formula:

=INDEX($A$1:$A$20,MATCH(MIN($C$1:$C$20),$C$1:$C$20 ,0))
Reply With Quote