I have been fighting with this for a few days, and I feel like I am missing something obvious.
I have two tables. First table is just the headers and one row of dropdowns
Table 1.JPG
2nd Table:
Table 2.JPG
So for the first table, the first dropdown is a validation list of the area column of table two.
Now I want the second dropdown to pull up the list from the 2nd or 3rd column based on the value selected in the first dropdown.
If I use this I can get DC1 or SV1, but I cannot figure out how to do the COUNTIFS section based on a variable column
Desired.JPG
Desired2.JPG
(Using Excel 2016)
Bookmarks