software

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 quot;C2quot;). 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

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!

quot;Treyquot; wrote:

gt; Hello,
gt;
gt; Strange thing happening here. I need to put several VLOOKUPS into a single
gt; sheet in a workbook. I am pulling the data from several different tabs (one
gt; tab per VLOOKUP). The first 3 VLs work fine. After that -- the VLs don't seem
gt; to be able to catch a whole range of text-populated cells (they all start
gt; with quot;C2quot;). I've tried most everything I can think of (changing the format of
gt; the cells from text to general to number and back again) and I've triple
gt; checked my VLOOKUP formulas -- they are exactly the same format as the one
gt; that work (and the ranges and values are all what they should be). Is there a
gt; limit to # of lookups you can have in a workbook?
gt;
gt; The _only_ thing I can think of is that I created the worksheets for the
gt; ones that don't work _after_ I inserted the initial VLOOKUPS into the main
gt; sheet. The other worksheets were created before I put any formulas in the
gt; main sheet.
gt;
gt; Additional advice?
gt;
gt; Thanks in advance!
gt;
gt; -Trey

If you can sort your lookup table that will dramatically improve the speed
of the Vlookup. By about 50%.

Biff

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