Vlookup with more than 15 digits

J

Julie

I'm using Excel 2003 and need to do a vlookup with more than 15 digits. Is
this possible?
 
G

Gord Dibben

You will need the digits in text format otherwise Excel will change anything
after the 15th digit to a zero.

Enter the digits preceded by an apostrophe.


Gord Dibben MS Excel MVP
 
E

Eduardo

Hi,

=vlookup(A1,B1:D10,2,false)

your number is in A1
your table is in B1 to D10, value to be extracted in column C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

more than 15 numbers in a cell? 7
More than 15 digits in excel cell it turns them to zeros. Fix? 1
vLookup a portion of a no. in a cell 3
15+ digit numbers 3
vlookup problem 4
How to save a 15 digit # in CSV without it changing to a formula? 1
Can I change the 15-digit limit in Excel for numbers ? 2
What function do I use to calculate a Sum of Digits? 3

Top