Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a 12 digit number in one area and doing the vlookup seems to be only
looking at the first 6 and rouding at that point. I need the lookup to look at the entire 12 characters and do a match on all 12. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Please post your formula, the input values, whether your table was sorted, the reply you expected and what you got instead.
We're not clairvoyant! -- Kind regards, Niek Otten Microsoft MVP - Excel "lloyd" wrote in message ... |I have a 12 digit number in one area and doing the vlookup seems to be only | looking at the first 6 and rouding at that point. I need the lookup to look | at the entire 12 characters and do a match on all 12. | |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You probably need to include the last option in the VLOOKUP formula........
=VLOOKUP(A1,MYTABLE,2,FALSE) Vaya con Dios, Chuck, CABGx3 "lloyd" wrote: I have a 12 digit number in one area and doing the vlookup seems to be only looking at the first 6 and rouding at that point. I need the lookup to look at the entire 12 characters and do a match on all 12. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Go back to your original posting to see some responses
Gord Dibben MS Excel MVP On Thu, 6 Dec 2007 11:09:02 -0800, lloyd wrote: I have a 12 digit number in one area and doing the vlookup seems to be only looking at the first 6 and rouding at that point. I need the lookup to look at the entire 12 characters and do a match on all 12. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Puzzle | Excel Discussion (Misc queries) | |||
A real puzzle? | Excel Discussion (Misc queries) | |||
VLOOKUP puzzle ?? | Excel Worksheet Functions | |||
Excel Puzzle | Excel Worksheet Functions | |||
Can you help!!!!! New Puzzle | Excel Discussion (Misc queries) |