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
 
Top