Odd vlookup behavior

[Jeffrey Green]

I have named range called REMOVE.
REMOVE is 24 Columns wide
When I enter

=VLOOKUP(A2,REMOVE,20,0), i get a valid response. When enter =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? <tbody> </tbody>

<tbody>
</tbody>

 

[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