Forum Discussion

kittenmeants's avatar
kittenmeants
Brass Contributor
Feb 05, 2024

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

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.

excel
Formulas and Functions
  • GeorgieAnne's avatar
    GeorgieAnne
    Iron Contributor
    Feb 05, 2024
    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.

Resources