EXCEL AND MS WORD...WHY CANT THEY GET ALONG....PLEASE HELP
Your post is cut off, it ends with
"Example: word docuement has "table four is next to table three"
in excel I have a column"
Nevertheless as far as I know you can't do vlookup in Word at all, you need
to copy it over to excel
2. you can use wildcards in a vlookup
=VLOOKUP("*"&A1&"*",Table,2,FALSE)
as an example
--
Regards,
Peo Sjoblom
"pam" wrote in message
...
I have a table in Word that has many rows and cells with text in it.
I have a column of text in excel.
I would like to get in excel the information from the work document of
just
the text that is found in my excel column.
I tried vlookup but the document in word may have a sentence in it and
vlook
look at a whole cell not part of it.
Thanks for the help very much.
Example: word docuement has "table four is next to table three"
in excel I have a column
|