vlookup problem

[Guest]

I am using Vlookup in an excel worksheet pulling descriptions from another
excel file but when I do it does not display the full description, only part
of it.

How can I solve this?

I would appreciate any help.

 

[º¼ÖÝÈË]

The logic is worth to establish to have and did not have problems

 

[Dave Peterson]

Maybe you could use =right(), =left(), or =mid() in your formula.

=mid(vlookup(a1,sheet2!a:b,2,0),12,22)

Excel's help describes these string functions.