=indirect (substitute (a2&b2, ,)) where a2 and b2 contain the first and second dropdowns,.

How to create drop down list in excel without data validation. I'll click in the source. On the second sheet, create the following named ranges. Web for example, in cell c2, the data validation formula would be:

Have a look at the structure below. Web i'll go to the settings tab, i'll hit the drop down by allow, and i'll choose list. Web on the data tab, in the data tools group, click data validation.

Web creating the drop down now that my list has been created, i can set up the actual drop down. To do this, i’m going to select a cell and under the data tab, click on. If you don't want users to.

Web y es, you can create a cell drop down without data validation. Now, i can either type the name or i can choose the name. In the data validation dialog box, do the following:

Select all the cells that you want to validate, we select cells b5 to b13. The data validation window will appear.