VLOOKUP approx. value

[DCM - Albert]

I have a list of numbers, ranging from 0 to 15 for the number of years an employee has worked. The number of years is in column D.

I have a list of numbers, 1, 1.5 and 2 which represent the number of vacation days earned per month. The number of days are listed in column L.

For 0-5 years, 1 day is earned. For 6-14 years, 1.5 days are earned. For 15+ years, 2 days are earned.

___K | L
4| _0 | 1
5| _6 | 1.5
6| 16 | 2

I did a vlookup as follows: =VLOOKUP(D13,K4:L6,2,TRUE)

Now, if the number is between 0 and 15, it only shows 1 for the number of days earned. It SHOULD be finding the 1.5, for anything over 5 but it seems to just overlook that line.

Any ideas as to why?

Thanks in advance.

 

[Jonmo1]

What happens with a value of 16 or more, does it show 2?

If so, I would think that the value in K5 is NOT a true number...but a number stored as text...

What does this return
=ISNUMBER(K5)

 

[DCM - Albert]

16 or more DOES in fact show 2 years correctly. Only the 5+ causes a problem.

=isnumber(K5) returns FALSE... How can I fix it?

 

[Jonmo1]

Format the cell K5 as general.
THEN, RE-Enter the number 6 into K5

 

[DCM - Albert]

You're the man.

That worked and was something I would literally have never done.