Looking for formula assistance. Have a series of columns, A-C, containing dollar values. I have column D set up to find the minimum value. Now in column E, I want to create a formula that will take the value found in colum D and return the header of column A-C that matches D (so Co A, Co B or Co C).
A B C D E
1 Co A Co B Co C Low Bid Low Bidder
2 $4.44 $3.75 $2.31 $2.31
3 $39.95 $44.31 $36.43 $36.43
4 $55.44 $62.33 $44.29 $44.29
I tried using a hlookup but I'm apparently not doing it correctly. Any solutions?
Thanks in advance.