I just noticed, you are using entire rows for your lookup ranges. Isn't that
wasteful/doesn't it end up taking too long for calculations? I don't know,
because I just now tried it on a very small range and it worked. But your
ranges are fairly large.
--
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))