He is using the whole sheet actually and beyond that unless he is using
excel 12, he could change that to
$1:$256 because that is what it is using excel 97 - 2003, if you type that
in the name box you'll see what I mean. If all the extra fluff is empty I
don't think it will matter much speed wise but it's not a good spreadsheet
design in general.


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"Kevin Vaughn" wrote in message
...
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))