Link to home
Start Free TrialLog in
Avatar of nomios
nomiosFlag for Afghanistan

asked on

VLOOKUP error from SharePoint data

Greetings,

I am using Excel 2010 and a SharePoint Survey to collect and track information.  I am using a VLOOKUP formula =IFERROR(VLOOKUP(A2,TrackingInfo!A:B,2,FALSE),"Not Shipped")  to match up account IDs with tracking information.

The information is coming from a SharePoint survey, which I download as an Excel file, then copy over to my master sheet.  The data is seemingly blocking my VLOOKUP because the info comes across as text - even though I'm switching it to 'general' or 'number.' When I try to change format from text, it seems to result in scientific number.  

Example:
The tracking number is 7012101000007924637, but is displayed as "7.0121E+18." Also when I click into a cell and press Enter - I get 7012101000007920000 for every result.

I'm grateful for any assistance.

Attached is a sample copy.
VLOOKUPHELP.xlsx
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

For numbers, Excel has a maximum precision of 15 digits.  To enter a "number" with more digits than that, you have to enter it as text.
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nomios

ASKER

Outstanding!

Thank you, Patrick!