# VLOOKUP Error #N/A Array Containing Formulas

#### G00DNESS

##### Board Regular
From Cell D37
I entered the formula:
Code:
``````[/SIZE][SIZE=1]=IF(OR(B37="",L36=""),"",IF(L36="SD",VLOOKUP(B37,H9:L33,4,0),IF(L36="MM",VLOOKUP(B37,H9:L33,5,0))))[/SIZE]
[SIZE=1]``````
The typed in value of D37 is 13.
H9:H33 have formulas that produce numeric values.
The formula-generated value in H15 is also 13.
This formula returns #N/A
There are some blank cells in Row H, but in row after H15.
If I type 13 in H15, my formula works, but not when 13 is generated from the formula within H15.
Code:
``````[/SIZE][SIZE=1]The formula in H15 is: =IF(I15="","",IF(OR(D15="",E15="",F15="",P15=""),"","13"))[/SIZE]
[SIZE=1]``````

Any help with this error is much appreciated.

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### joeu2004

##### Well-known Member
Change "13" to 13 -- remove the quotes. Never  put double-quotes around numbers that you expected to be interpreted numerically.

-----
 Never say "never". There is one exception that I use myself. But it applies only to numbers that are used in expressions; and I'm one of very few people that ever need to do it.

Last edited:
• G00DNESS

#### G00DNESS

##### Board Regular
Change "13" to 13 -- remove the quotes. Never  put double-quotes around numbers that you expected to be interpreted numerically.

-----
 Never say "never". There is one exception that I use myself. But it applies only to numbers that are used in expressions; and I'm one of very few people that ever need to do it.
Thanks so much Joeu004! Works well.