Hi Bernie,

Thank you very much for your time and assistance. Your addition to the
formula has done the job brilliantly, and is very much appreciated. It works
Great!

I've been trying to sort that for more hours than I care to remember!

Cheers,
Sam

Bernie Deitrick wrote:
Sam,

You need to use an IF to test the value and return the correct evaluation:

=IF(AND(Q18=$Q$4,R18=$R$4,S18=$S$4,T18=$T$4,IF(C2 ="",OFFSET($Q18,1,0,,1)0,OFFSET($Q18,1,0,,1)<0)) ,"Yes","")

HTH,
Bernie
MS Excel MVP

--
Message posted via http://www.officekb.com