Hi

Something like (I assume values in column C are really numbers, i.e.
percentges)
=SUMPRODUCT(--($A$2:$A$100=P2),--($B$2:$B$100=2005),$C$2:$C$100)
to calculate Q2, and
=SUMPRODUCT(--($A$2:$A$100=P2),--($B$2:$B$100=2006),$C$2:$C$100)
to calculate R2


Arvi Laanemets


"Michele" wrote in message
...
I'm trying to create an IF statement that will give me either of two
values
from a table by using a vlookup. Here's a sample

Col A Col B Col C
Row1 Empl ID Year Def. %
Row2 123 2005 ???
Row3 345 2006 ???

Containing the following named table (Deferred_Perctg):

Col P Col Q Col R
Empl ID 2005-% 2006-%


Here is what I'm trying to write, but can't seem to get it to work.

If

((B2=2005),(=VLOOKUP(+A2,Deferred_Perctg,2,False)) ,(=VLOOKUP(+A2,Deferred_Pe
rctg,3,False)))

What am I missing? Any help would be greatly appreciated!

Thank you,
Michele