Odd vlookup behavior

[Jeffrey Green]

I have named range called REMOVE.
REMOVE is 24 Columns wide
When I enter [TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl63, width: 106"]=VLOOKUP(A2,REMOVE,20,0), i get a valid response.
When enter [TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl63, width: 106"]=VLOOKUP(A2,REMOVE,24,0)
I get #N/A Error. ???
I can understand a #REF errror, but how can i get #N/A by simply changing the index/Row number? [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jeffrey Green]

Solved, i am an idiot. There were 25 columns, i wanted 25, not 24. Column 24 had "#N/A" from a formula in that cell. duh