How do I get the VLOOKUP function to work on large table arrays (>40,000
rows)? Excel doesn't seem to see the cells in the array unless I use the
edit command on the coresponding lookup value in the array.

I'm using Excel 97. The table array is a downloaded Crystal Reports file.