Extracting data from table for related table

I have the below table (snap shot of large data)


I want to extract the starting & Ending Number for the below Name & Number, so how can I do that.Here please note that the

Name Number Starting Number Ending Number
B 01/2013B 123 135
B 02/2013B 1500 1650
B 03/2013B 1600 1760
B1 01/2013B1 1750 1925
B1 02/2013B1 500 550
B1 04/2013B1 600 660
B1 06/2013B1 800 880
D 01/2013D 550 605
D 05/2013D 650 715
D 06/2013D 780 858
D 02/2013D 850 935

I want to extract the starting & Ending Number for the below Name & Number, so how can I do that. Here pleae note that in the above table the position of col 3 & 4 will keep changing (like, 6&10 or 8 & 15 respectively).

Name Number Starting Number Ending Number
B 01/2013B ? ?
B1 02/2013B1 ? ?
D 06/2013D ? ?

Thanks,

Could you give an example of the desired output?

Still unable to understand your problem.

Please attach a sample workbook.

Deep

Suggest you use a Vlookup function.

http://www.techonthenet.com/excel/formulas/vlookup.php

You just need to use a VLook Up.

Please see the file attached. See the formula in the colored section.

Hope I understood you correctly.

Deep

Look at columns D & E in the attached.