ExcelBanter - Vlookup with more than 15 digits

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup with more than 15 digits (https://www.excelbanter.com/excel-worksheet-functions/253011-vlookup-more-than-15-digits.html)

Julie

Vlookup with more than 15 digits

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

Gord Dibben

Vlookup with more than 15 digits

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
wrote:

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

Eduardo

Vlookup with more than 15 digits

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?

All times are GMT +1. The time now is 12:53 PM.