J
Julie
I'm using Excel 2003 and need to do a vlookup with more than 15 digits. Is
this possible?
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
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
10,2,false)
your number is in A1
your table is in B1 to D10, value to be extracted in column C
=vlookup(A1,B1
10,2,false)your number is in A1
your table is in B1 to D10, value to be extracted in column C