Vlookup problem

[Nalex]

Hi,

I have a vlookup that is giving me some trouble.

On sheet1, I am receiving data that is a 12 digit number, and I am then using a formula to only take the 1st 8 digits of this number.

Then on sheet2, I have a simple formula/reference (=Sheet1!A2) to bring that number into sheet2, where the vlookup uses this number to look-up data on another sheet ( =VLOOKUP($A2,Sheet3!$A$1:$H$1500,COLUMN(),0) ).

My problem is that the vlookup formula is not displaying the results when I use the "=Sheet1!A2" formula to bring the 8 digit number into the sheet. It works great when I hand enter the number on Sheet2, but not when I use this formula.

Any help would be greatly appreciated.

Thanks

 

[T. Valko]

Hi,

I have a vlookup that is giving me some trouble.

On sheet1, I am receiving data that is a 12 digit number, and I am then using a formula to only take the 1st 8 digits of this number.

Then on sheet2, I have a simple formula/reference (=Sheet1!A2) to bring that number into sheet2, where the vlookup uses this number to look-up data on another sheet ( =VLOOKUP($A2,Sheet3!$A$1:$H$1500,COLUMN(),0) ).

My problem is that the vlookup formula is not displaying the results when I use the "=Sheet1!A2" formula to bring the 8 digit number into the sheet. It works great when I hand enter the number on Sheet2, but not when I use this formula.

Any help would be greatly appreciated.

Thanks

Sounds like you have a data type mismatch.

The numbers in your lookup table are numbers but the lookup value is a TEXT string (even though it might look like a number).

What does the formula look like where you:

I am then using a formula to only take the 1st 8 digits of this number.

 

[SteveO59L]

How are you extracting the first 8 digits ?

 

[Nalex]

Thanks for your help, I am using:

=LEFT(a5,8)

The 12 digit number is in a5

Thanks

 

[T. Valko]

Thanks for your help, I am using:

=LEFT(a5,8)

The 12 digit number is in a5

Thanks

Does that formula return a "number" that has any leading zeros?

Try it like this and see if it makes a difference:

=--LEFT(A5,8)

 

[Nalex]

That fixed it.... Working great now.

Yhank You very much!!!

 

[T. Valko]

That fixed it.... Working great now.

Yhank You very much!!!

You're welcome. Thanks for the feedback!