You can see the details on my Contextures website, Dependent Lists page, and download the sample file. =INDIRECT( VLOOKUP(B2,INDIRECT( VLOOKUP(A2,ProductLookup,2,0)&”Lookup” ),2,0)&”List”) Download the Sample File
#Pick from a list in excel for mac code
Put the list items in the first column, and a short code for each item in the second column.
Instead of trying to substitute every illegal character, you can set up a lookup table. It’s simple to use the SUBSTITUTE function to get rid of any spaces, but your list of items might contain other characters that can’t be used in range names, such as an ampersand (&) or asterisk (*). The formula also removes any spaces in the text, by using the SUBSTITUTE function, because the range names can’t use space characters. There is a named range on the worksheet – RedFruit – and the data validation formula uses the INDIRECT function to create a reference to that range. Here is a nice, simple conditional list – if you select Red Fruit in cell A2, you can see a list of red fruit in cell B2. But what about making a third drop down list? And how can you work with spaces, or other characters that can’t be used in Excel names? It’s fairly easy to make one drop down list show items based on what was selected in another drop down.
0 kommentar(er)
