Merge Many Dropdown with airSlate SignNow

Generate dropdown lease

How can we create a dependent drop-down list on every row in Excel? So I've made a few videos about how you can create dependent drop-down lists in Excel. I even have an entire playlist dedicated to it. Here's a common question I get. How can I create multiple dependent data validation lists on the same sheet. There are different approaches to this, and it can get quite complicated. I'm going to show you a version that requires one single formula that gets the job done. (upbeat music) We're going to create our dependent drop-down list in these rows right here. The first choice is to select a division, and the second choice is to select an app. Now the app choice that we're going to get here is based on the division that's selected right here. Now you can see our data set here. We have the divisions listed on top and these are the apps that belong to each division. Now for the purpose of the video, I've put this data set right beside my selection just so that it's easier for us to create the formula. You're probably going to have this sitting on a separate tab or sitting, well on this side, hidden from view. First off, let's start with the division. That's the easy one, right? That's just a drop down containing these three, so let's go ahead and do that. Go to the data tab, click on data validation right here. Under list, we're going to go with this as our source, and click on okay. So notice everything is fully fixed, which is perfect because I'm planning to copy this and paste it to here. Okay so now when I click on this, I can select between these three divisions. Now, here comes the difficult part. We need to create a dependent drop-down list that's based on this. So if the user selects utility, we want to give the user a choice of these apps. I'm going to do that using the offset formula. Now just to be sure that I get the formula written correctly, I'm going to write it right here. Once I have a good feeling that it works, then I'm going to copy it into the data validation box. So the formula that I'm going to use is the offset function. Choices for offset are right here. Now I also have a separate video covering offset in more detail, and I've added it to description of the video and also to the cards. So make sure you check it out if you need more information about offset. First argument is the reference. Reference is your starting point, because what the offset function does is it gives you back a range that's a few steps away from your reference point. Now those few steps are things that we can define right here. So it makes sense that our reference point is close to our data set. So I'm going to...