Thanks! both were very helpful, and TIMELY!!!!!!

"Larry S" wrote:

Look at the function ISERROR to be used as an error handler around the
VLOOKUP...do something as follows:

=IF(ISERROR(VLOOKUP(___,____,___,___)),"",VLOOKUP( ___,____,___,___))

what this will do is first attempt to evaluate the VLOOKP, if an error
results, it will post a null ("") in the cell, if it was successful, it will
reevaluate the VLOOKUP and post the desired result.


"Mr. Boyer" <Mr. wrote in message
...
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?