Forum Discussion
Drop Down List with Linked Columns
Hello: I am trying to figure out how to create a drop down list with multiple linked columns; but let me explain as it is different from what I am seeing on the forum and other sites. I have...
I'd create two named ranges
one for data validation list
='Vendor Contacts'!$A$2:INDEX('Vendor Contacts'!$A:$A,COUNTA('Vendor Contacts'!$A:$A))and another for vendor info range
='Vendor Contacts'!$B$2:INDEX('Vendor Contacts'!$D:$D,COUNTA('Vendor Contacts'!$A:$A))using first in data validation and second to pickup the info as
=IFNA(INDEX(VendorsRange,MATCH($L2,VendorsList,0),MATCH(M$1,'Vendor Contacts'!$B$1:$D$1,0)),"")
Select the cell where you want the first (main) drop down list.
Go to Data –> Data Validation. ...
In the data validation dialog box, within the settings tab, select List.
In Source field, specify the range that contains the items that are to be shown in the first drop down list.
Click OK.
Go to Data –> Data Validation. ...
In the data validation dialog box, within the settings tab, select List.
In Source field, specify the range that contains the items that are to be shown in the first drop down list.
Click OK.
