P
Pank
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.
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.