I've got a form as an Excel document, and I'm trying to set it up so that it will autocomplete cells with text.

To start - a cell with a drop-down menu, with several vendors as items in the drop-down list, and what I'd like to do is make the shipping method cell in the form and the payment method cell auto-complete once you choose the vendor.

Like...
(cell 1 --> cell 2 --> cell 3)

Acme Inc --> Will Call --> Send Bill

Beav LLC --> Ship to Cthulhu Industries --> Pay by Visa

Dwarven Corp. --> Will Call --> Charge to Paypal Acct


Does that make sense?

Also, Excel is kind of a legacy choice - if Excel won't do this, is there a better choice of program?

Thanks in advance!