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 chose someone's name, I want the data to pull in and link with their corresponding region and provide the sales number. I can't seem to find a simple formula, or maybe I need more than one?
See attached.
Thank you!
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'.
3 Replies
Here's a 365 solution:
=LET(col, XMATCH(E4, Sheet2!C2:K2), CHOOSECOLS(Sheet2!C5:L9, col, col + 1))- 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?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'.