Vlookup returning value at bottom of range.

[parbynat]

Merry Xmas forum.

In A1 I have 7.14
in B1 I have =VLOOKUP(A1,C1:D5,2,TRUE)
Range C1:D5 contains the values below.

7.4 1
7.2 2
7.0 3
6.8 4
6.6 5

I want to return 2 but I am returning 5.

Can someone help with this?

Thanks

[AliGW]

For an approximate match, the lookup values need to be in ascending order. Try INDEX MATCH with a -1 match.

[bebo021999]

Because C1:C5 is decreasing, try MATCH instead:

=INDEX(D1:D5,MATCH(A1,C1:C5,-1))

[parbynat]

Spot on guys.

Many thanks