Put this in D1 and fill down as needed: =IF(OR(A1=408, A1=409,
A1=410...A1=415),C1,"")

Dave
--
Brevity is the soul of wit.


"Karen Smith" wrote:

Is there a formula I can use that says if A:A = 408 409, 410, 411, 412 or 415
then put the contents of C:C in column D?