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_Perctg,3,False)))

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

Thank you,
Michele