Create dependent dropdown lists

Hi everyone, I'd like to make a list at column D of the example image I've attached. Let's say for example D39. As you can see, some cells in the same row on the right side have values whilst others have empty outcome. I'd like it to make a list that, whenever there is a value, it creates a list with the top text, so for example D39, the list should say "Aproximación" and "PAPI". The range of the list goes from column E to BA and there are like 10 thousand rows, so its quite a lot of data.

In case it's possible, it would be great if the list could give only values which are greater than 0, smaller than 0 BUT greater than a given value on a cell (B2 for example) or no list in case the whole row is empty. I guess it's not very easy and hope I explained myself clearly, thanks!

Jindon was kind enough to try to help me but for some reason it doesnt seem to work for me, the code is the following,

Please Login or Register  to view this content.

https://www.excelforum.com/excel-pro...nk-or-not.html

Hi, sorry that I can't attach the original one but Ive attached an example which I think will work.
In this example, the list should be all empty except for D8 cell (should say Transición 02), D10 (Aprox. 02 and Transicion 02) and D18 (cónica).
Note that D18 should say only cónica because it is greater than zero, so any other value less than zero should be ignored.