Prev: test posting calculations formula tab
Next: Auto Sum range with multiple columns.
From: Julie on 11 Jan 2010 14:02
I'm using Excel 2003 and need to do a vlookup with more than 15 digits. Is
this possible?
From: Gord Dibben on 11 Jan 2010 14:23
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


On Mon, 11 Jan 2010 11:02:01 -0800, Julie <Julie(a)discussions.microsoft.com>
wrote:

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

From: Eduardo on 11 Jan 2010 14:49
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

"Julie" wrote:

> I'm using Excel 2003 and need to do a vlookup with more than 15 digits. Is
> this possible?
 | 
Pages: 1
Prev: test posting calculations formula tab
Next: Auto Sum range with multiple columns.