Posted by Gary_41701 on April 18, 2001 9:26 PM
There's a debate going @ work regarding processing
time. We use vlookup (s) to do a lot of reporting.
Some of the files are extremely large (3 mg or better -
Yes, I know we should use Access -- anyways). The
source data comes down in thousands and must be
converted to millions to conform to Corp Standards.
One group claims that Excel processes data faster
if on your reporting Tabs --You insert your vlookup(s)
below the reporting section & reference those #'s into
the formatted schedules & dividing same by a "1000".
I find it hard to believe that it's faster than just
inserting a vlookup formula directly into the
reporting section of the tab and incorporating the
dividing \ rounding factor in the vlookup formula.
Any input would be appreciated.
Please skip the custom formatting route - been there.