Find the cheapest supplier name

**makinmomb** · 05-14-2015, 11:30 PM

Expected answer by for formula on i3
suppplier 3
Expected answer by for formula on i4
suppplier 2

Formula on i3 to drag down

**Nisha Dhawan** · 05-14-2015, 11:40 PM

Hi,

Enter the following formula in I3 and drag it to the down.

Formula:

=INDEX($D$2:$F$2,1,MATCH(MIN(D3:F3),D3:F3,0))

Please let me know if it solve your purpose.

**makinmomb** · 05-15-2015, 12:03 AM

Yes thanks , I was just leaving for work

I am glad I got to carry it

**Nisha Dhawan** · 05-15-2015, 12:52 AM

Thanks Makinmomb for your kind words and reputation.

Re: Find the cheapest supplier name