davidryoung
Board Regular
- Joined
- Feb 7, 2005
- Messages
- 110
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
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