Jump to content

Select list item which then auto insert data in to another cell


Recommended Posts

Hi all,


I'm trying to create a purchase order form in Excel, what I would like to happen is that I put the supplier number in to one cell which triggers the address cell to be auto-completed. I have created two lists with both the supplier number and the corresponding address; I just need to be able to link them together somehow.


Any help greatly appreciated.





Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.