search for a number in a range

Hi,
I have this workbook which has two sheets dump and Primary data,serials numbers are entered in dump sheet.Primary data sheet contain start and end serial no in column C & D respectively and distributor name in column E.
I want macro which will search for which range(column C & D of Primary data) each serial falls in dump sheet and also will provide the distributor name.

uploaded the original file from in.xls