Hi All and thanks in advance for any help given
I am trying to produce an order form which allows users to select parts from a predetermined list,which can be selected by part number or description and autofill each other as required, for instance if I select a description it will autofill part number and if I select part number it will auto fill description,I am stuggling to think of how to do this without vba, it may not be possible.
Andym
Use Vlookup() Function
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Is this what you're looking for?
This is a simple solution and will only work as long as the names of the parts are all unique. This is because of the specifics of VLOOKUP.
EDIT:
Also this solution only allows for you to select a part by its name - the other values will fill in with VLOOKUP. As far as I know you can't have a drop-down and VLOOKUP in the same cell, that would require a different approach.
Last edited by bmouse; 11-03-2014 at 05:55 AM.
Unfortunatly this is the function I require!!Originally Posted by bmouse
Thanks for your help andy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks