Good eye. It was the range. Is there a way to unlimit the top range so I
don't run into this as my records grow?

"Kevin Vaughn" wrote:

Ok, the thing I notice is that you use 2 different ranges in your vlookups.
in the one where you are checking for an error, the range is $1:$2500 and in
the one where you are actually doing the lookup it is $1:$1940 so if you are
getting an #N/A error that would indicate that the value is in the range
1941:2500 but not in the range 1:1940. Also, if I could I would like to
point out if you are only trying to get rid of #N/A errors, you should use
the ISNA function instead. ISERROR includes all errors including #N/A, such
that you could be potentially masking an error that you should be dealing
with. And, FWIW, ISERR includes all errors except #N/A.
--
Kevin Vaughn


"Darrel A" wrote:

I am using the same formula on several different worksheets. Some work and
some return #N/A as a result. Any suggestions? Here is my formula:

=IF(ISERROR(VLOOKUP((CONCATENATE($C42,"INSQUOTE-AUTO")),Pronto2!$1:$2500,8,FALSE)),"",VLOOKUP((CON CATENATE($C42,"INSQUOTE-AUTO")),Pronto2!$1:$1940,8,FALSE))