Seperate colum B into 2 columns... Lower Range and upper range..
then the values in each column will be numeric and you can use simple
lookups.

"Pank" wrote:

I have the following: -

Col B Col C Col D
Row 25 127.8
Row 26
Row 27
Row 28 110 £86.49
Row 29 111 €“ 114 £89.07
Row 30 115 €“ 118 £91.65
Row 31 119 €“ 122 £94.23
Row 32 123 €“ 126 £96.81
Row 33 127 €“ 130 £99.31
Row 34 130 102.00


I need to compare the value stored in D25 against B28:B34 and when a value
is found to report out the corresponding value from C28:C34.

Therefore if D25 were 127.8, I would expect to see a value of £99.31 to be
populated in cell F32.

Thank you in anticipation.