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