In this video, I'm going to show you how to create a dependent drop-down list. The challenge here is that our headers and lists are not sitting right beside each other, but they're sitting right below each other. In a previous video, I showed you how to make a dependent drop-down list using the index function. However, our data was given to us in separate columns. The question then arises: How do you handle cases when your data is not sitting right beside each other, but they're actually sitting right below each other, and each of these has different sizes? To solve this, I will show you how to create a dependent drop-down list with a data set like that. The master data for our lists is structured in such a way that on the left-hand side, we have the division, and on the right-hand side, we have the app names that belong to each division. We have three divisions: productivity, game, and utility. The first drop-down list allows the user to select the division. The second drop-down list will be dependent on the selection made in the first one. I will demonstrate how to create this using the offset function. If you're not familiar with offset, I have a video that explains the basics of this formula. You can find the link in the description below. Offset is like a GPS. It doesn't need a predefined map on where it should move. Instead, you need to give offset a starting point, and then it can move anywhere you want it to. In this case, our starting point will be close to our answer, which is here. However, the starting point can vary depending on your preference. The next argument in the offset function determines how many rows to move down. In this case,...
Award-winning PDF software
Video instructions and help with filling out and completing What Form 2220 Dependents
