Forum Discussion
Solved
Creating a workbook - drop down list selection help
Hello, I am creating a workbook with a drop-down list and need some help with linking the data. Sheet1 has the outline Sheet2 is raw data DropDown has a list of individuals names When I c...
For Sarah/VA, you could use INDEX/XMATCH:
=INDEX(Sales,XMATCH(E10,Regions),XMATCH(E4,Names))With the attached workbook I've created dynamic items for 'names', 'regions', and 'sales'.
Is there an alternative formula that we can use to support if we gain more regions or need to break out the sales status further down the line?
i.e. i there a quick way to just match Sarah - VA - to C9?
i.e. i there a quick way to just match Sarah - VA - to C9?
For Sarah/VA, you could use INDEX/XMATCH:
=INDEX(Sales,XMATCH(E10,Regions),XMATCH(E4,Names))
With the attached workbook I've created dynamic items for 'names', 'regions', and 'sales'.