Lookup's for and totals

[Purfleet]

I have a large spreadsheet (like the sample below) and i need to be able to
look in the Score(us) column and if a certain number is reached (adding up
the column)then look up the Opponents

i.e
1 Canvey Island Reserves
10 Brentwood Reserves

Date Opponents Result Score(us) Score(them)
24-Aug-85 Canvey Island Reserves Won 3 0
26-Aug-85 east thurrock United Reserves Won 3 1
31-Aug-85 Brentwood Reserves Won 5 1
04-Sep-85 witham town Reserves Won 2 1
07-Sep-85 eton manor Reserves Won 1 0
14-Sep-85 maldon town Reserves Won 3 0
21-Sep-85 eton manor Reserves Draw 2 2
28-Sep-85 Sawbridgeworth Town Reserves Won 6 1

I can get this to work if the number is exsact by using the Lookup function,
but not if the number i lookup falls in the middle.

 

[bj]

I have a large spreadsheet (like the sample below) and i need to be able to
look in the Score(us) column and if a certain number is reached (adding up
the column)then look up the Opponents

i.e
1 Canvey Island Reserves
10 Brentwood Reserves

Date Opponents Result Score(us) Score(them)
24-Aug-85 Canvey Island Reserves Won 3 0
26-Aug-85 east thurrock United Reserves Won 3 1
31-Aug-85 Brentwood Reserves Won 5 1
04-Sep-85 witham town Reserves Won 2 1
07-Sep-85 eton manor Reserves Won 1 0
14-Sep-85 maldon town Reserves Won 3 0
21-Sep-85 eton manor Reserves Draw 2 2
28-Sep-85 Sawbridgeworth Town Reserves Won 6 1

I can get this to work if the number is exsact by using the Lookup function,
but not if the number i lookup falls in the middle.