Index/Match Formula - Help

[Lisa_Cupcake]

Hi,

This is my first time so please bear with me

I have a spreadsheet which consists of multiple items with multiple quantity breaks. I have found the cheapest price per quantity break and now I am trying to find the relevant supplier.

I have successfully done it for the first quantity break however when I use the same formula (with the exception of the match component) I am not getting a valid result and cant work out why.

=INDEX(B$1:S$1,,MATCH(U3,B3:S3,0))

If I change the match to W3 I get a answer of zero

 

[Aladin Akyurek]

Let B3 and N3 house the cheapest value, say $ 10.00 and any other cell a value > $ 10.00. Don't you want to see as the results the values of B1 and N1?