Posted to microsoft.public.excel.misc

Colin

Posts: n/a

Vlookup to word

I am trying to have word pull data from excel which is using the Vlookup
command. To avoid the #na problem I expanded the formula to this:
=IF(ISERROR(VLOOKUP(M2,'C:\Documents and
Settings\coline\Desktop\VLOOKUP\All_Course_Info.xl s'!Couses,2,FALSE)),"-",
VLOOKUP(M2,'C:\Documents and
Settings\coline\Desktop\VLOOKUP\All_Course_Info.xl s'!Couses,2,FALSE))

But, the data is cut off when it goes in to word. It displays some of the
data it is supposed to lookup but not the whole.

Any help is appreciated. Thansk

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP IF Cell Contains a Word within Text	DAWN	Excel Discussion (Misc queries)	3	April 5th 23 01:07 PM
Linking table in Excel to word	travis	Links and Linking in Excel	1	November 19th 05 02:30 PM
Tricky ... Pullout related rows that match a single word using Vlookup	YJL	Excel Discussion (Misc queries)	18	November 14th 05 08:22 AM
Vlookup for part of a word	jenhow	Excel Worksheet Functions	7	April 29th 05 10:22 PM
Vlookup of parts of a word in a range of Data	Andre Croteau	Excel Discussion (Misc queries)	3	December 19th 04 07:26 PM

All times are GMT +1. The time now is 10:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us