I have a number of tables in Excel and I want to use drop down lists to limit the data that can be keyed into certain fields. I can create simple drop down lists with dependent drop downs but I'm not sure if I can use tables where there would be multiple columns of data.
What I have are two tables. One is about 25 columns and the other is 7. The common denominator between the two is a numberid code. There is one occurrence of this code in the 25 column table and several occurences in the 7 column table. The code number code means little to the end user. It is the description fields in the next column that are needed for entry. These are not all unique so I can't rely on them.
My goal in Excel is to select an item from the 25 column table, have that trigger a dependent list from the 7 column table. The number from the seven column table would then be used in calculations against the fields in the 25 column table.
Is it possible to use a table instead of one column lists for data validation in excel and achieve what I want to do?