Correction.

=IF(AND(L17=11%,N17=4),2000,
IF(AND(L17=11%,N17=3),1500,
IF(AND(L17=3%,N17=3),VLOOKUP(N17,array,column,0),
IF(AND(L17=4%,N17=4),VLOOKUP(N17,array,column,0)," Conditions not met"))))

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try..

=IF(AND(L17=11%,N17=4),2000,
IF(AND(L17=11%,N17=4),1500,
IF(AND(L17=3%,N17=3),VLOOKUP(N17,array,column,0),
IF(AND(L17=4%,N17=4),VLOOKUP(N17,array,column,0)," "))))

If this post helps click Yes
---------------
Jacob Skaria


"exceldrivesmecrazy" wrote:

IF L17 0.06 AND N17 3, then 2000, else 1500, for lookup xxxxxxxxxx

I need to compare two cells for each person to determine a raise. If they
are x amount over a setpoint (L17 6%) and they have been evaluated as a 4
in N17, then give them $2000, else lookup their evaluation # and plug in the
raise.
examples
L17 =11% and N17 =4 would equal $2000
L17 =11% and N17 =3 would equal $1500
L17 =3% and N17 =3 would equal Lookup eval 3 for xxxx
L17 =4% and N17 =4 would equal Lookup eval 4 for xxx