vlookup problem

[Jeanette]

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!

 

[Bob Phillips]

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]

There are no leading zeros. Example: 45203010, and only the first 4 digits
4520 are appearing in my destination spreadsheet.

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)

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!

 

[vezerid]

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

There are no leading zeros. Example: 45203010, and only the first 4 digits
4520 are appearing in my destination spreadsheet.

Is it leading zeroes? If so, just format the cell as 00000000

(there's no email, no snail mail, but somewhere should be gmail in my addy)

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!

 

[Jeanette]

I changed the formula a bit, but it did work - Thank You!!!!

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

There are no leading zeros. Example: 45203010, and only the first 4 digits
4520 are appearing in my destination spreadsheet.

Is it leading zeroes? If so, just format the cell as 00000000

(there's no email, no snail mail, but somewhere should be gmail in my addy)

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!