Incorporation of Data Into Separate Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LDWyatt - 28 Feb 2005 00:07 GMT

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?

Reply to this Message

Jason Marshall - 28 Feb 2005 10:13 GMT

Autopopulation in Excel can only take effect after the field has already
been entered once.

Unless, you are talking a IF Formula.

If cell A1 = <A> then Vendor ID = <V ID> and <Cost Code>

That is possible with standard IF formula's.

HTH

--

>I have 3 columns of data in Excel: Vendor Name, Vendor ID and Cost Code.
>In
[quoted text clipped - 3 lines]
> enough,
> but I can't figure it out. Can anyone help?

Reply to this Message