VLOOKUP Error #N/A Array Containing Formulas

[G00DNESS]

From Cell D37
I entered the formula:

[/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.

[/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.

 

[joeu2004]

Change "13" to 13 -- remove the quotes. Never [1] put double-quotes around numbers that you expected to be interpreted numerically.


-----
[1] 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.

 

[G00DNESS]

Change "13" to 13 -- remove the quotes. Never [1] put double-quotes around numbers that you expected to be interpreted numerically.


-----
[1] 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.