On Sep 14, 11:36*am, 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

This will work for your first example....

=IF(AND(L170.06,N173),3000,1500)

This would work for the first three.....
if you need to do more than those scenarios, a User Defined Function
with SELECT CASE might be better off.

=IF(AND(L17=11%,N17=4),2000,IF(AND(L17=11%,N17=3), 1500,IF(AND
(L17=3%,N17=3),VLOOKUP(value,table,colno,FALSE),IF (AND
(L17=4%,N17=4),VLOOKUP(value,table,colno,FALSE),"E RROR"))))