Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup size limitations search range?
Hi,
I'm experiencing problems with vlookup and I'm afraid it's linked to the size of the range in which I look. This is a table of 5 columns and approx 1300 rows. And records that are in row 1200 (approx) and below return a #N/A when search for by vlookup. (I tested this with changing the sorting from ascending to descending and then looking again for the record I needed.) I must say that the file in which the vlookup is called has 6 columns of each approx 120 rows with vlookup functions. I cannot imagine that this is already at/over the limits of excel? The version I'm using is 2003 SP2 Can anyone help me out? Thanks, Hans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CAN VLOOKUP SEARCH AN ENTIRE WORKSHEET INSTEAD OF RANGE OF CELLS | Excel Worksheet Functions | |||
Size/memory limitations for vlookup fixed in the new Excel? | Excel Discussion (Misc queries) | |||
CAN YOU DYNAMICALY CHANGE VLOOKUP SEARCH RANGE? | Excel Discussion (Misc queries) | |||
size limitations on auto filter | Excel Discussion (Misc queries) | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions |