Contrary to popular belief, editing files online can be hassle-free. Sure, some file formats might seem too hard with which to deal. But if you have the right solution, like DocHub, it's easy to edit any file with minimum effort. DocHub is your go-to solution for tasks as simple as the ability to Index Dropdown Object For Free a single file or something as intimidating as dealing with a massive stack of complex paperwork.
When it comes to a solution for online file editing, there are many solutions out there. However, not all of them are robust enough to accommodate the needs of people requiring minimum editing capabilities or small businesses that look for more advanced features that enable them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing documents online more streamlined and easier. Sign up for DocHub now!
[Music] in this lecture I want to show you the index function from a different angle most cases of index is is fused with a match function and its used to get data or do complex lookups from larger data tables so in this case its a bit different Im going to use the index function to select between different lists here I have list one list two lists three and what I want is that if the user selects two here that it shows the earth names that are in list two and if you select three they get the app name from list three Im going to use the index here first argument is the array so what should it be should it be this entire range here should it be just this so remember that index is like a GPS right and it needs a map and the map that I give it should be the map where my answer is in its not necessary to give it areas where for sure my answer is not there and in this case my answer should be one of these three because the next cell below it should be one of these three so I dont nee