Looking up a value

[neville]

Hi out there,

Its not as simple as it looks (for me that is). Can someone give me a hand please.

I have a column with text values like (row 1 to 3) 'HR wer ND 1' & 'HR wer ND 2' & 'HR wer ND 3' these represent quotes.

In the cells next to them there are values like 'blank £200 & £125'.

On most occasions there will only be one quote value next to one of these text values.
I am trying to figure out the best formula to lookup and return the cheapest quote value (like £125) and (HR wer ND 3)the text value.

Any Ideas??

Thanks in advance
Neville

 

[Squad]

Hopefully this helps. Ive used two formulas within the data. 1st one is a min formula and the 2nd one is a match index formula (based off of the min result):

Min Formula: c4:c6 = $ values

=MIN(C4:C6)

Match Index Formula: b4:b6 = "text - HR wer...", c8 = min , c4:c6 = $ values

=INDEX($B$4:$B$6,MATCH(C8,$C$4:$C$6,0))

 

[neville]

Hi there Squad,

Many thanks for that - It was the 'MIN' statement that I was missing (Doh!!.. so obvious).

Rgs Neville.