How to create a multiple drop-down lists in Excel using Developer?

[PetarTen]

Hi Folks, I'm struggling to find a short Video where to see how I can make a Multiple Drop-down Lists using Developer Mode Box.
I don't want to use the data validation tool for several reasons, so if anyone here has come across a video or online lecture or presentation where this "trick" is shown - please comment


Btw, this article here is useless - Insert a multiple-selection list box - Microsoft Support
The idea is to make a Multiple Dropdown Lists like this guy here:

...but using the Developer.
Cheers!

 

[6StringJazzer]

Here is an update to your file. It adds two columns to the engine table, one to indicate that engine is for BP and one for Shell. An array formula in the first sheet replaces your INDEX formula to list the engine types available for the listed oil.

Please download the file as I cannot guarantee it will be there forever.

Dropbox

www.dropbox.com

 

[PetarTen]

Here is an update to your file. It adds two columns to the engine table, one to indicate that engine is for BP and one for Shell. An array formula in the first sheet replaces your INDEX formula to list the engine types available for the listed oil.

Please download the file as I cannot guarantee it will be there forever.

Dropbox

www.dropbox.com

I’m working at the moment mate, Tonight I’ll download it and check the progress

 

[PetarTen]

Here is an update to your file. It adds two columns to the engine table, one to indicate that engine is for BP and one for Shell. An array formula in the first sheet replaces your INDEX formula to list the engine types available for the listed oil.

Please download the file as I cannot guarantee it will be there forever.

Dropbox

www.dropbox.com

Hi Jeff,
I see this:

 

[6StringJazzer]

Delete the formula in F7 and try again.

 

[6StringJazzer]

 

[PetarTen]

View attachment 119565

You mean from F7, Sheet1 ?
Here it is.... the Cell is empty ....but still see #NAME everywhere
Hmmm...

....including here:

Interesting tho... the Formulas in F Column are different from what they're before:

 

[6StringJazzer]

Your profile says you are using Excel 365, but whatever version of Excel you are really using doesn't recognize the FILTER function. That's why your formula bar shows "_xlfn" and returns a #NAME error.

I can't hit a moving target.

 

[PetarTen]

Your profile says you are using Excel 365, but whatever version of Excel you are really using doesn't recognize the FILTER function. That's why your formula bar shows "_xlfn" and returns a #NAME error.

View attachment 119589

I can't hit a moving target.

Аs I stated earlier --> How to create a multiple drop-down lists in Excel using Developer?
...I'm using 2016 version (please don't kill the messenger)

 

[PetarTen]

Your profile says you are using Excel 365, but whatever version of Excel you are really using doesn't recognize the FILTER function. That's why your formula bar shows "_xlfn" and returns a #NAME error.

View attachment 119589

I can't hit a moving target.

I created an Account with Microsoft simply to use Office 365
Here's the result:

If you tell me how to download the Office 365 App (they don't call it "Software" anymore), I might be able to properly open the File.
Thanks for your efforts! Highly appreciate it

 

[PetarTen]

Btw, I was thinking of a way to solve this problem (the relation between both Dropdown Lists) by somehow imitating SUMIF Formula described here:

I.e. to enumerate the Cells from Table 4 (divided with commas) which we need to be shown (to hold) in B2 Dropdown list.