| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you change single digits to recognized double digits? | Excel Worksheet Functions | |||
| number 12 digits to 15 digits | Excel Discussion (Misc queries) | |||
| 11 digits | Excel Worksheet Functions | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| Match 9 to 11 digits - vlookup | Excel Discussion (Misc queries) | |||
Linear Mode
