Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |