Something similar to VLOOKUP in Word?

[Nan]

Is there a way to create a lookup table, or something that works like a
lookup table in Word 2003 SP2? What I'm trying to accomplish is, when a user
chooses a vendor name from an AutoTextList field, I'd like the vendor number
to automatically populate another field.

 

[Doug Robbins - Word MVP]

' Macro created 15-11-97 by Doug Robbins to add the address corresponding to
a drop down name

'

Set myDrop = ActiveDocument.FormFields("Dropdown1").DropDown

Company = myDrop.ListEntries(myDrop.Value).Name

Address = ActiveDocument.AttachedTemplate.AutoTextEntries(Company).Value

ActiveDocument.FormFields("Text1").Result = Address


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP