Vlookup will not work

[almst791]

Hey guys,
Column A I have digit 00075003025
Column B I use the "Right function" to change the value to 75003025
Then in column C I have a vlookup to get the description of this 75003025 code

It comes up N/A but my table I use for vlookup that 75003025 description is there. If I change cell B1 to the actual number and not the right function it works. Why is this?

Excel 2007

 

[63falcondude]

Try adding +0 to the end of the right function. The result of a RIGHT function is considered text. Chances are that the numbers in your lookup table are seen as numbers and not text.

 

[gaz_chops]

Because your right formula is returning a text value, try adding +0 to the end of the formula, as below

=RIGHT(A1,8)+0

 

[almst791]

you guys are awesome. HOW DO YOU KNOW ALL THIS ****

 

[gaz_chops]

Learnt a lot from this forum

 

[63falcondude]

you guys are awesome. HOW DO YOU KNOW ALL THIS ****

Glad to help. I agree with gaz_chops. I have learned so much from helping others on this forum.