CptFujMnky
ExcelRobot
/ multi-level data validation.lambda
Last active
July 22, 2024 21:04
Multi-Level Data Validation LAMBDAS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Name: Multi-Level Dropdown Validation (MultiLevelDropdownValidation) | |
| Description: Returns the list of allowable values for a specific cell based on | |
| the entries to the left. | |
| Parameters: | |
| tablename - name of the Excel table containing the data validation dropdowns. | |
| header - table header cells from the first column with data validation to the column for which | |
| to return list of values allowed. | |
| keylisttable - reference to dynamic range containing the MultiLevelKeyLists lambda key lists table. | |
| Source: Written by Excel Robot, inspired by Wyn Hopkins (https://www.youtube.com/watch?v=r0DTFodQYJQ&t=989s) |