Excel tutorials

In this part we are going to explain how we can lookup values between two values – and return a corresponding result.

Below we have some temperatures, to the right is our lookup and references.

Take the first temperature, its 0 – if we look in our right table the result will be “Early spring”.

Select cell B4 and enter the below formula:

=LOOKUP(A4;D4:D9;F4:F9)

Now, here we cannot just drag the formula down, that will change the formula where to look for the values. To fix this we need to make the references absolute.

To adjust that, simply add dollarsigns for the references like below:

=LOOKUP(A4;$D$4:$D$9;$F$4:$F$9)

The final result will be like this: