Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Reporting/Tracking Data Workbook (multiple selections w/drop down)

Brass Contributor

Hello! 

I have the attached workbook (most of the information is redacted) and need help extracting data when I choose a specific name from the drop down. 

 

In a perfect world, I would choose someone's name in cell E4, and their sales and info would populate in the table. The information (raw data) is generated weekly, and I drop it into Sheet2. 

We frequently change individuals (names), but the layout stays the same. 

 

I am stuck at what formula to use that would give me that information. I would like to use a formula in each cell vs one that encompasses everything.

1 Reply
Hello @kittenmeants
Sorry the workbook is useless. I could not figure out what you need!

So, what I would suggest is to look into these functions

XLOOKUP,
COUNTIF
COUNTIFS
SUMIF
SUMIFS.

If you need any help using these come back with a DETAILED description of what you are trying to do,

G.