Forum Discussion
kittenmeants
Feb 05, 2024Brass Contributor
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...
- Feb 05, 2024
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'.
kittenmeants
Feb 05, 2024Brass Contributor
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?
Patrick2788
Feb 05, 2024Silver Contributor
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'.