INDIRECTO Function with Drop down list and NUMBERS

%3CLINGO-SUB%20id%3D%22lingo-sub-77287%22%20slang%3D%22en-US%22%3EINDIRECTO%20Function%20with%20Drop%20down%20list%20and%20NUMBERS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-77287%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%26nbsp%3Bwant%20to%20create%203%20dependient%20list.%20The%20first%20one%20is%20the%20list%20%22TIPO%22%20(Green)%2C%20the%20seconds%20are%20the%20list%20in%20blue%20and%20the%20third%20are%20the%20lists%20in%20red.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F15737iADFCE1A6619BBEB5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%221.JPG%22%20alt%3D%221.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20the%20first%20list%20I%20want%20to%20select%20the%20type%20of%20cylinder%2C%20with%20the%20second%20one%20the%20bore%20diameter%20size%20for%20this%20types%20of%20cylinder%20and%20with%20the%20third%20one%20the%20career%20available%20for%20one%20type%20of%20cylinder%20with%20a%20specific%20bore%20diameter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20I%20create%20the%20first%20list%20in%20one%20cell.%26nbsp%3B(Type%20of%20pneumatics%20cylinders)%3C%2FP%3E%3CP%3ESecond%20I%20use%20the%20function%20INDIRECTO%20to%20create%20dependient%20list.%26nbsp%3B%20(Bore%20diameters)%3C%2FP%3E%3CP%3EThird%20I%20want%20to%20create%20another%20dependent%20list.%20(Career)%20but%20the%20problem%20is%20that%20I'm%20using%20numbers%20and%20I%20can%20not%20use%20a%20number%20for%20a%20range%20name.%20And%20I%20need%20a%20number%20because%20after%20select%20all%20I%20do%20a%20filter%20to%20find%20the%20different%20elements%20in%20the%20data%20base.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F15739i07E62BAF7E973ADE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%222.png%22%20alt%3D%222.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%223.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F15740iAB9EF71625D20B12%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%223.jpg%22%20alt%3D%223.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20someone%20know%20how%20to%20create%20that%20%3F%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-77287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EShow%20and%20Tell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi,

I want to create 3 dependient list. The first one is the list "TIPO" (Green), the seconds are the list in blue and the third are the lists in red.

1.JPG

 

With the first list I want to select the type of cylinder, with the second one the bore diameter size for this types of cylinder and with the third one the career available for one type of cylinder with a specific bore diameter.

 

First I create the first list in one cell. (Type of pneumatics cylinders)

Second I use the function INDIRECTO to create dependient list.  (Bore diameters)

Third I want to create another dependent list. (Career) but the problem is that I'm using numbers and I can not use a number for a range name. And I need a number because after select all I do a filter to find the different elements in the data base.

2.png3.jpg

 

Does someone know how to create that ?

Thanks!!

 

0 Replies