I have a report where I am weighting results for several locations always
listing a rolling three months, and an average for those three months
In column A is Ranking the locations by highest to lowest results
In column B are the locations
In column C is Jan, D is Feb, E is March, F is Q1
In columns I - L are call volumes for the above months.
Columns M - P takes the results for each month and * by the call volume in I
- L.
I then take certain groups of locations and divide their weighting in
columns M - P by their call volume in I - L. For example: Locations in row
2,3,4,8,12 need to be combined. It is random rows every month depending on
the result for that month. This is a time consuming effort as I'm manually
enter each results with the corrisponding location.
What I would like to do is see if there is a formula to look for the
locations and the results in the correct columns and divide them to create
the weighted result. I want to say this is probably a VLookUp formula but I'm
not too familiar with it and can't seem to figure out how to put the division
in there or even if it's possible.