Hi,

Is it possible to use VLOOKUP in a SUMPRODUCT calculation? I have a large
series of data and I want to count the number of instances where a row has
several criteria - and I can nearly cover it in a single SUMPRODUCT formula.

An example of the data I am counting is:
Priority Included Achieved
A Yes Q2 2007
A Yes Q1 2008
A No Q1 2008
B Yes Q1 2008
A Yes Q2 2008

and I am looking to count the number of priority A's that have a "Yes" in
the column Included and were achieved in Q2 2008 or before. So in this
example the count would be 3.

The problem I have is that one of my criteria is that a milestone achieved
was in the quarter I am looking at or before. The data in this column is in
the form "Q[NUMBER] [YEAR]" (see example above). The way I am planning to do
is to have a lookup table elsewhere which converts each quarter into a ranked
number e.g.:
Quarter Rank
Q1 2008 1
Q2 2008 2
Q3 2008 3

Any ideas how to get the VLOOKUP to work in the SUMPRODUCT function - please
help me!!!

Sorry if its not that clear but let me know what clarification you need

Thanks in advance

Ed