ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   vlookup problem (https://www.excelbanter.com/excel-worksheet-functions/22608-vlookup-problem.html)

Jonny

vlookup problem
 
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

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




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.

Jonny wrote:

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.


--

Dave Peterson


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com