• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index formula with multiple Matching values including an OR

S

Style

New Member
I know I need to be using an INDEX formula and a combination of MATCH formulas to accomplish my objective, but I can't seem to get it quite right.

I am attaching a file for reference.
There is a data tab that everything references. I have many more columns in mine and the come in from a database system download, so the formatting is not changing month to month (however, I can not control the order of the columns as it comes in).
I am looking to create some tables on the Chart tab using the data.
The charts are by District, listing each store and the management levels at each store.
All stores will not have the same number of each level of management and there could be multiple of the same level at a given store.

I know that I should be able to say if given District =X AND store #=X , give me the name of the person at Mgmt level "Mgr" and the give me the next person and so on. Ideally, in the Mgmt level column it will automatically figure out based on the data how many of what type of Mgmt is in each store. The OR value comes in as the store will either have a "Mgr" or "T Mgr" but not both.

I appreciate any help that you can provide.
 

Attachments

Perhaps this is not what you're wanting/looking for/needing... but have you tried creating a pivotTable based on the Data Sheet?
I created one with the following fields in this order all in the Row Fields section:
District
Store#
Job Title Abbr
Employee
This will group your data first by District, then inside each district it will group by store #, then for each store number it will list the Job Titles as they apply and list the name of the individual with said job title.
Maybe I’m misinterpreting, but that sounds like what you were describing.
 
A pivot table would work, but unfortunately I have to make it "pretty" for distribution and the look of the pivot table is not what they are looking for.
I appreciate the suggestion though.
If you have other ideas on how to get the formulas to work, let me know.
 
This is great.
Thank you azumi.
Question, is there an easy way to get the job titles to group together in the table?
 
You must log in or register to reply here.
Back
Top