Hi Guys,

I have a set of data in excel spread sheet attached herewith.

With a fixed allotment of money(budget), a consumer has to identify the best price offered by the supplier. The table attempts to identify the best price offered by the supplier on different products, viz. fridge, washing money etc.

Utilizing the "match function" available in excel sheet the best price of the supplier closest to the budget price was identified. But the output was in numeric value which spots out the position only. But I want the name of the supplier available in the column heading to be shown as output instead of the position.

Sample sheet showing the table and desired result is enclosed for reference
With regards,

varadhu

In C2, then copied down:

=INDEX($D$1:$G$1, MATCH($B2, $D2:$G2, 1))

Wonderful!!

It really worked.

Thank you!
Varadhu

Quote:

---

Originally Posted by JBeaucaire

In C2, then copied down:

=INDEX($D$1:$G$1, MATCH($B2, $D2:$G2, 1))

---

I have seen your posts and also your site.

You are really wonderful. Actually after seeing your posts, I wanted to post the query direct to you. But wondered whether the forum rules as well as you would appreciate the same.

As I expected, it is you, who had replied.

Hats off and Thank You once again.

Varadhu

Glad you like the site, lots to peruse and use, hope you do.

Best to post your questions in the public forum for the benefit of all.