One common error is referencing.
Check if the grid that you are referring to is absolute, that is does it
have $ before the row and column.

$A$1:$A$1000 is the correct method.

Also, if you are referring to numbers, if the numbers are stored as text you
get #N/A.

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Mike" wrote:

The Vlookup formula returns #n/a instead of a number in several rows in my
worksheet. If I retype the lookup number or add a ' in front of the lookup
number, the formula will work. However, I have hundreds of rows of data and
would have many #N/A's to correct using this method. Does anybody know how
to correct the formula, etc. to prevent this?
--
Thanks,
Mike