Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - Is there a Maximum number of entries?
I'm using Excel 2003 and am running into a problem. At the top of my table,
all returned values are correct. Later on in the table... DEFINITELY at the end, the returned entries are wrong! Not even close to what they should be... as a matter of fact. I copied the same formula all the way down the spreadsheet and |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - Is there a Maximum number of entries?
How about some info as to your layout and your formula
-- Don Guillett Microsoft MVP Excel SalesAid Software "bobbymak" wrote in message ... I'm using Excel 2003 and am running into a problem. At the top of my table, all returned values are correct. Later on in the table... DEFINITELY at the end, the returned entries are wrong! Not even close to what they should be... as a matter of fact. I copied the same formula all the way down the spreadsheet and |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - Is there a Maximum number of entries?
Is the lookup_range part of the formula anchored?
"bobbymak" wrote in message ... I'm using Excel 2003 and am running into a problem. At the top of my table, all returned values are correct. Later on in the table... DEFINITELY at the end, the returned entries are wrong! Not even close to what they should be... as a matter of fact. I copied the same formula all the way down the spreadsheet and |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a maximum with VLOOKUP | Excel Discussion (Misc queries) | |||
EXCEL MAXIMUM VALUE AND VLOOKUP NESTED? | Excel Worksheet Functions | |||
vlookup for maximum value | Excel Worksheet Functions | |||
vlookup maximum cell range? | Excel Discussion (Misc queries) | |||
maximum entries | Excel Worksheet Functions |