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

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

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