I am trying to figure out how to use data from the attached spreadsheet to consolidate and evaluate data.
Essentially I need to query the data on the "Feb 2011- Data" tab to lookup the salesman account # and set name and number of times used each month. I would like to put this figure on the "2011 EC" in order to evaluate the usage of each set and which salesman are using them.
For example, I have highlighted on the first tab what I would need to pull. I want to see the number of times salesman 703521 has used set name 112A in the month of February. I need to do this with each salesman/set for upcoming months as that data becomes available and I can substitute a new table into the "Feb 2011- Data" tab as fresh data is available.
I thought I was getting close with the use of MATCH, but can't seem to get this to pan out.
Appreciate any help on this one.
Bookmarks