# Excel Formula

[Closed]
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
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?
Barb

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
INE2 type this formula

copy E2 down

It happens that the minimum in each row of your data is in col. 3

try with this data

Co A Co B Co C
\$4.44 \$3.75 \$2.31
\$25.00 \$44.31 \$36.43
\$55.44 \$42.00 \$44.29

D2 will have formula
=min(A2:C2)
E2 will have above formula

copy D2 and E2 down.