You can display a standard value for not found entries, using an IF statament:
=IF(ISNA(VLOOKUP(...),"Value not found",VLOOKUP(...))
Also, check the four parameter of VLOOKUP, if you don't have the list sorted
it is better to use FALSE there.

Hope this helps,
Miguel.

"Mr. Boyer" wrote:

I am trying to use a VLOOKUP from a large set of data to a smaller set of
data (the array does not contain all of the values being looked up), and thus
returns #N/A.
It works for the first value which is in the table, but as soon as there is
a value missing, all other returns are #N/A as well. Is there any way to get
around these absent values?