#N/A and Vlookup error

[davidryoung]

I am using the following formula and array, and it is working just fine except for the lowest value <11 which is returning a #N/A error. If I add the FALSE to the range lookup to the other two VLOOKUPs it will work but not sure why. The formula works on all values except that one.

IF(F18="","",IF(ISNA(VLOOKUP(F18,D3S1358,2,FALSE)),K58,IF(VLOOKUP(F18,D3S1358,2)>K58,VLOOKUP(F18,D3S1358,2),K58)))

D3S1358
<11 0.0009 0.00161 0
11 0.00271 0.00161 0.0014
12 0 0.00804 0.0014
13 0.00271 0.00643 0.00698
14 0.13653 0.08521 0.07542
15 0.27034 0.31672 0.38687
15.2 0 0.00322 0
16 0.22242 0.2926 0.26257
17 0.20072 0.21383 0.16201
17.1 0 0 0.0014
18 0.1519 0.06913 0.09218
19 0.01175 0.00161 0.00978
>19 0 0 0

 

[davidryoung]

Still looking for help on this. I have multiple arrays like this, but only three give me problems and they all have the lowest value using the less than (<) sign.

 

[Jonmo1]

Try changing the <11 to 0

 

[davidryoung]

The <11 is the value that is being looked up and cant be changed. The <11 is entered on one worksheet and the formula looks up the values to be used to calculate a statistic. There are 32 entries and 16 arrays involved in this calculation and everything works perfect except these three values, all of which contain a less than symbol. I have other entries containing the greater than symbol which also work fine.
Any ideas??

 

[davidryoung]

Still looking for ideas on this?