[Free Excel Tutorial] USE INDIRECT FUNCTION TO CREATE A 2ND PICK FROM LIST - Full HD
[Free Excel Tutorial] USE INDIRECT FUNCTION TO CREATE A 2ND PICK FROM LIST - Full HD
This video is in response to a viewer who wants to join two columns containing Data Validation “Pick-from” lists. She knew that there was a Formula that could perform this, but she didn’t know how to accomplish this.
This is not a “Perfect” solution. As you can see, when you change the value in the first drop-down list, the value in the second list remains in place. What does change, however, is the list of values now available in the second drop-down list – waiting for you to make your selection!
Last week we started to explore the capabilities of Excel Data Validation and learned how tocreate a simple drop-down list in Excel based on a comma-separated list, range of cells or a named range.
Today, we are going to investigate this feature in-depth and learn how to create cascading drop down lists that display choices depending on the value selected in a previous dropdown.
Limit the choices in an Excel drop down list, by using named ranges and the INDIRECT function, to create dependent data validation lists. For example, select Fruit in column A, and only Fruit items appear in the drop down list in column B
In this dependent data validation example, if a country is selected from the first drop down, only that country's cities appear in the next column's drop down list.
However, you can use the Excel IF function to make the selection more flexible. If no country is selected, the City column will show a list of world cities in the dependent drop down list.
Free Excel Tutorial, USE INDIRECT FUNCTION TO CREATE A 2ND PICK FROM LIST, Full HD
Free Tutorial, USE INDIRECT FUNCTION TO CREATE A 2ND PICK FROM LIST, Full HD
Excel Tutorial, USE INDIRECT FUNCTION TO CREATE A 2ND PICK FROM LIST
This video [Free Excel Tutorial] USE INDIRECT FUNCTION TO CREATE A 2ND PICK FROM LIST - Full HD is copyrighted for Rui Ludovino channel: • [Free Excel Tutorial] USE INDIRECT FUNCTIO...