yogi_If Name Matches In Column D Of MASTER And Date In Column DH Of Master In The Corresponding Row Is Between Dates In Cells C1 And D1 Then return 0.5 Else 0