VLOOKUPS: Limits on # per sheet?
 

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

VLOOKUPS: Limits on # per sheet?
 

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

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