Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup problem
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup problem
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup problem
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup problem
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem | Excel Worksheet Functions | |||
VLOOKUP and IF AND problem | Excel Discussion (Misc queries) | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
vlookup problem | Excel Discussion (Misc queries) | |||
vlookup Problem | Excel Discussion (Misc queries) |