"Look-Up" Function

S

Suzie

Does anyone know if or how to simulate a lookup function
in Word, similar to that in Excel. We want to build a
document that would give a definition based on the code of
an item. This would be similar to an autofill feature,
although the descriptions may be several lines long. A
merge feature may work, also, although we may have too
many fields to work with and we'd like to automate this
file as much as possible. The Lookup function in Excel
seems to be the best match so far, but it is not as
flexible when using that program for a text document.

Any ideas?
 
M

macropod

Hi Suzie,

Word doesn't have a Lookup function, or many of the other
functions supported by Excel. Word, does, however, have an
IF function, and you may be able to achieve what you want
by nesting some of them.

Check of the IF field in Word's help - the Word 2000
version shows the syntax for mailmerges, and you can us
that for other purposes too - just remember to enclose the
text for each true/false statement in quotes, and that the
field braces (ie {}) are created as pairs by typing Ctrl-
F9.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top