Array Formula to Return a Text Value

[Bharlan]

Here is what I'm looking to do:

2015-05-27_1437.png

My formula in B2 is:{=MIN(IF(D2:H2<>0,D2:H2))}

And as you can see it returns the low bid for that item.

What I'm trying to do now is to return the name of the Bid Winner from D1:H1

I have tried : {=MIN(IF(D2:H2=B2,$D$1:$H$1))}

and I get a return of 0.

Can anybody help?

[AlKey]

Array formula entered with Ctrl+Shift+Enter

to get the names

=INDEX($D$1:$H$1,MATCH(MIN(IF(D2:H2<>0,D2:H2)),$D$2:$H$2,0))

[Bharlan]

Deleted post

I'm very new here. Did I do something wrong?

[AlKey]

I'm very new here. Did I do something wrong?

No, You're fine. It was me

[Bharlan]

Great!! Thank you

[AlKey]

You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).