NeoGen Posted January 22, 2013 Share Posted January 22, 2013 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. Regards N Link to comment Share on other sites More sharing options...
sheffeeld Posted January 22, 2013 Share Posted January 22, 2013 Pretty crude, but you can expand upon... PM me if you need further help https://www.dropbox.com/s/lkiinsenxlrfphv/lookup.xlsx Link to comment Share on other sites More sharing options...
max Posted January 22, 2013 Share Posted January 22, 2013 Duplicate answer Link to comment Share on other sites More sharing options...
Afilsdesigne Posted January 22, 2013 Share Posted January 22, 2013 Hi NeoGen. Try this: http://www.dt4u.com/filearea/forumorders.xls Link to comment Share on other sites More sharing options...
NeoGen Posted January 23, 2013 Author Share Posted January 23, 2013 Many thanks Guys, looks like the answer is using the lookup function, I will try this and let you know how I ge on. Many thanks N Link to comment Share on other sites More sharing options...
NeoGen Posted March 5, 2013 Author Share Posted March 5, 2013 Hi all, I used the Vlookup function that is working a treat, so thanks all for your help. Regards Nick Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now