Vlookup? Index/Match? If?

[Geezuss]

[TABLE="width: 448"]
<tbody>[TR]
[TD]Value:[/TD]
[TD="align: right"]4533[/TD]
[TD][/TD]
[TD]Ratio:[/TD]
[/TR]
[TR]
[TD]Returned Value:[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fund[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]4533[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]654654[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]357[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]84768[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]110[/TD]
[TD="align: right"]64[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]115[/TD]
[TD="align: right"]34[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]120[/TD]
[TD="align: right"]6154[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]200[/TD]
[TD="align: right"]56484[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]200[/TD]
[TD="align: right"]84984[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]200[/TD]
[TD="align: right"]6846[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]4564[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]564987[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]6848[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]500[/TD]
[TD="align: right"]687465[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to sum the amounts based on the fund number (e.g. sum of amounts of all 100-level funds, including 110, 115, 120). Then, I need to calculate a formula so that whenever the user inputs a value that matches with one of the amounts, the formula computes the following ratio --> inputted value: sum of all amounts of similar fund level. For example, if the user inputted 4533 and 4533 matches one of the enlisted amounts, then the formula would do 4533 / sum(a14:a20).

Note: I calculated the "Returned Fund" with =INDEX(A14:A28, MATCH(C10, B14:B28)). I thought this may be a helpful reference when creating a formula.

This is a project given to me at work, and no one else knows much about Excel except me. I've tried to create formulas for the past few hours using a combination of VLOOKUP, INDEX, MATCH, and IF but I still haven't gotten a successful output after multiple failed attempts.

Can someone please guide me in resolving this problem?

 

[mart37]

=iferror(b1/if(match(b1,b4:b17,0)>0,sumproduct(--(left(a4:a17,1)=left(b2,1)),a4:a17*b4:b17),0),"")