vlookup
 

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.

vlookup
 

Take a look at VLOOKUP In XL Help, you need to set the range_lookup
argument to FALSE, e.g.:

=VLOOKUP(A1,J:K,2,FALSE)

In article ,
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.

vlookup
 

Above 9 try formatting as text

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

vlookup
 

I have false in the correct position


"JE McGimpsey" wrote:

Take a look at VLOOKUP In XL Help, you need to set the range_lookup
argument to FALSE, e.g.:

=VLOOKUP(A1,J:K,2,FALSE)

In article ,
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.

vlookup
 

When I do text formatting it appearing as 12452145E12

"Don Guillett" wrote:

Above 9 try formatting as text

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

vlookup
 

I am new to this so just checking to see if this was received


"lloyd" wrote:

When I do text formatting it appearing as 12452145E12

"Don Guillett" wrote:

Above 9 try formatting as text

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

vlookup
 

Then please provide some examples of your data (in a message, not an
attachment), along with your formula(e), that illustrates the problem.



In article ,
lloyd wrote:

I have false in the correct position


"JE McGimpsey" wrote:

Take a look at VLOOKUP In XL Help, you need to set the range_lookup
argument to FALSE, e.g.:

=VLOOKUP(A1,J:K,2,FALSE)

In article ,
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.

vlookup
 

Are both the vlookup table, and the cell you are looking at of the same
format? Just a thought.
--
Best Regards,

Luke M


"lloyd" wrote:

I am new to this so just checking to see if this was received


"lloyd" wrote:

When I do text formatting it appearing as 12452145E12

"Don Guillett" wrote:

Above 9 try formatting as text

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

vlookup
 

Just doubled check and to it's ok. to be sure I copied the format from one to
the other.

"Luke M" wrote:

Are both the vlookup table, and the cell you are looking at of the same
format? Just a thought.
--
Best Regards,

Luke M


"lloyd" wrote:

I am new to this so just checking to see if this was received


"lloyd" wrote:

When I do text formatting it appearing as 12452145E12

"Don Guillett" wrote:

Above 9 try formatting as text

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

vlookup
 

Post your formula and a sample of 12-digit numbers.

Also, how are the 12-digit numbers produced?


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 09:54:04 -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.

vlookup
 

"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.

I don't know so well, but is your table sorted an ascending order?

JG