Compare a Named Range and Volitile Range

[ourgarden]

I am trying to figure out how to compare each value in a Named Range: PATROLCODE (E3:E52) to another volitile range. The volitile range includes the rows above the current cell address (BA63) and could include a varied number of columns to the right based on another cell (in this case (BA61:BB62). The value appearing in both lists it is passed over untill a value in the Named Range is not duplicated and is entered in this cell.

I have included a copy of the file:
http://wikisend.com/download/443100/Event Scheduler.xls