# #N/A and Vlookup error

#### davidryoung

##### Board Regular
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

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### davidryoung

##### Board Regular
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

##### MrExcel MVP
Try changing the <11 to 0

#### davidryoung

##### Board Regular
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

##### Board Regular
Still looking for ideas on this?

Replies
4
Views
619

1,195,633
Messages
6,010,818
Members
441,569
Latest member
PeggyLee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back