search for a number in a range

[arnab0711]

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

[Richard Buttrey]

Your attached file does not contain the two sheets you mention.

[arnab0711]

sorry for the mistake,have uploaded the original file