vlookup problem

J

Jonny

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

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