• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Number more than 16 digits

A

Ashish Batham

Member
hi,

I have some number is a column, in file-1, however these are more than 16 digits. I need to do a vlookup for some of these numbers in file-2.
As these numbers are more than 16 digits, the numbers at the end turns to 0. I am not able to do a vlookup.
 
How are the values stored in the cell?

If it's a number then you are dealing with Excel's specification limits. If it is stored as Text then you can use VLOOKUP like you would on normal Text.
 
It would be possible ... as syntax tells:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
range_lookup:
If TRUE or omitted, an approximate match is returned.
In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned.
 
You must log in or register to reply here.
Back
Top