vlookup problem
I changed the formula a bit, but it did work - Thank You!!!!
"vezerid" wrote:
What if you try the INDEX/MATCH equivalent? Does it produce the same
problem?
=INDEX(E$2:E$501,MATCH(A7,'[sp 500 constituents.xls]Classification'!A
$2:A$501,0))
Does anything change?
Kostis Vezerides
On Feb 14, 6:52 pm, Jeanette
wrote:
There are no leading zeros. Example: 45203010, and only the first 4 digits
4520 are appearing in my destination spreadsheet.
"Bob Phillips" wrote:
Is it leading zeroes? If so, just format the cell as 00000000
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jeanette" wrote in message
...
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!
|