I have a vlookup formula setup as follows:
=VLOOKUP(A7,'[sp 500 constituents.xls]Classification'!A$2:J$501,5,0)
The value listed in column 5 on "the sp 500 constituents" spreadsheet has a
8 digit number. This value is only showing the first 4 digits in the second
spreadsheet, where I need data. I have checked the format, so that they both
show as numbers. What could be the problem as to why the result only shows
the first 4 digits? Help!