2 Column Dropdown List That Must Match Dependent on Selection.

[LibertyAvenger]

Hi All,

I currently have a PO tracking sheet which requires both The vendor name and vendor id to be present on the sheet for each recorded purchase order.

What I am looking to accomplish is having users be able to make a selection from whichever column and have the corresponding data populate. So say for Example.

Row 4 Select “Vendor Name” under Vendor Name Column drop down list. This event triggers the matching vendor ID to populate in the vendor ID column.

The predicament is I need this to happen in both directions and change based on the current selection being made. I.e.

I selected the vendor name already but we’ve changed our mind. I know the vendor ID of the new selection and select vendor ID now the vendor name should change based on last input made.

Imagine Vlookup references cells like a mirror that reflects back the data set for that column. But obviously this isn’t a capable thing in excel alone which is why I believe there may be an elegant solution via VBA. I had seen something similar in this forum but I cannot find it again.

Sorry for the long post but if more information is needed I’ll do my best to respond a little more succinctly.

 

[LibertyAvenger]

You can try using a free Excel add-in called "Search deList". Here:

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

Which part do you need an explanation?
If you're not familiar with "Worksheet Change Event" you can read this article:

VBA Worksheet Change Events — Excel Dashboards VBA

Automatically run an excel macro when a cell changes with Excel vba. Run a macro on double click. Run a macro before close

www.thesmallman.com

I’m unfortunately not familiar with VBA at all. My way of understanding it is if you had to tell me a story in layman’s of what each line of code is doing. Sorry I’m probably asking for a lot here. I just feel it irresponsible to take code that you worked on and not learn to understand it better.

 

[Akuini]

I’m unfortunately not familiar with VBA at all.

Sorry, the code is a bit complex, so it's hard for me to explain it if you don't have basic knowledge of vba.
To understand the code you need to learn about these terms: Find, Function, ListObjects, Worksheet_Change, Application.EnableEvents.