![]() |
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. |
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