VLOOKUPS: Limits on # per sheet?
If you can sort your lookup table that will dramatically improve the speed
of the Vlookup. By about 50%.
Biff
"Light" wrote in message
...
I find that it takes too much memory to do too many lookups, so after each
one I copy all the data and paste special values over the top (keeping the
formula as a comment just in case). Good Luck!
"Trey" wrote:
Hello,
Strange thing happening here. I need to put several VLOOKUPS into a
single
sheet in a workbook. I am pulling the data from several different tabs
(one
tab per VLOOKUP). The first 3 VLs work fine. After that -- the VLs don't
seem
to be able to catch a whole range of text-populated cells (they all start
with "C2"). I've tried most everything I can think of (changing the
format of
the cells from text to general to number and back again) and I've triple
checked my VLOOKUP formulas -- they are exactly the same format as the
one
that work (and the ranges and values are all what they should be). Is
there a
limit to # of lookups you can have in a workbook?
The _only_ thing I can think of is that I created the worksheets for the
ones that don't work _after_ I inserted the initial VLOOKUPS into the
main
sheet. The other worksheets were created before I put any formulas in the
main sheet.
Additional advice?
Thanks in advance!
-Trey
|