I have 3 columns of data in Excel: Vendor Name, Vendor ID and Cost Code. In
a separate document/form, I want to type the first word in the Vendor Name
and have the entire Vendor Name, Vendor ID and Cost Code for that vendor
automatically populate specific locations on the form. Seems simple enough,
but I can't figure it out. Can anyone help?