This might be what you're looking for, if not it will at least point in the
right direction:

=IF(AND(P13=A1,P13<=B1),D1,IF(AND(P13=A2,P13<=B2 ),D2))
--
Kevin Backmann


"Angela" wrote:

Hello,

I'm trying to find the correct value for P14.

If P13=A1 and <=B1 Then P14=D1
Else
If P13=A2 and <=B2 Then P14=D2

I have alot of numbers to go thru, is there an easy way to do this?

Any help would be greatly appreciated

Thank You
Angela