Forum Discussion
Excel functionality for returning values
Hi all, I am trying to create a dashboard where if a state is selected from a drop-down and the company supports that state, it will return the company name. Basically, my data table is below. I...
Here's a refinement. Assuming you might want to add options under each state, this (after you've added the acceptable answers to the list in Data Validation) will give you a list that meets an individually chosen criterion for the state. The FILTER function can be extended to allow for other kinds of combinations. Here's a video explaining it.
