Check that your data is properly sorted, and your range correctly defined.
There isn't an inherent limit: the function works as expected on correct
data, to the full limit of the spreadsheet.


"Bobby" wrote in message
...
Has anyone else had problems with VLOOKUP if there are more than 250 rows
the
VLOOKUP value defaults to 00000 instead of returning a value from the
column
in which it is supposed to extract from.