Hi,

Am Tue, 24 Mar 2015 20:08:29 +0000 (UTC) schrieb tb:

Min. (col. A) Max. (col. B) Part Number (col. C)
------------- ------------- --------------------
0 9 70-4906-0007
10 19 70-4906-0015
20 29 70-4906-0016
30 39 70-4906-0008
40 49 70-4906-0003

insert your part numbers without hyphen and format the cells
00-0000-0000
Then you can use in B1:
=SUMPRODUCT(--(Sheet2!$A$2:$A$100<=A1),--(Sheet2!$B$2:$B$100=A1),Sheet2!$C$2:$C$100)
and format column B also
00-0000-0000


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional