Excel Formula [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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?
Thanks in advance.
Barb

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
INE2 type this formula

=INDIRECT(ADDRESS(1,MATCH(MIN(A2:C2),A2:C2,0)))

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!