 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007vlookup 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! Is it leading zeroes? If so, just format the cell as 00000000  Signature--- 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) [quoted text clipped - 7 lines] > shows > the first 4 digits? Help! 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 > [quoted text clipped - 9 lines] > > shows > > the first 4 digits? Help! 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 <Jeane...@discussions.microsoft.com> wrote: > There are no leading zeros. Example: 45203010, and only the first 4 digits > 4520 are appearing in my destination spreadsheet. [quoted text clipped - 20 lines] > > > shows > > > the first 4 digits? Help! 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? [quoted text clipped - 31 lines] > > > > shows > > > > the first 4 digits? Help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.