What Formulas or Functions to use??!!!

[aeiou]

I have been struggling with my excel. Can someone tell me how and what
can do find the fees earned monthly(13/3 weeks) for each child? Th
family's income and number of children affect the fees each child'
fee. (Assumption: All family's children are 2-5 years old with
parents)

*Maximum charge for each child is $300 and the minimum is $40 a month.

'EXCEL FILE...CLICK HERE!
(http://s26.yousendit.com/d.aspx?id=2WSOUHRDQ5CRJ0UU7K66DTQJQB )

Thanks!! :

 

[olasa]

I think this fomula should work for you:
=INDEX($O$4:$R$14,MATCH(VLOOKUP(O17,$H$2:$L$31,3,0),$N$4:$N$14,1),MATCH(VLOOKUP(O17,$H$2:$L$31,4,0)-2,$O$3:$R$3,1))*VLOOKUP(O17,$H$2:$L$31,5,0)*$L$39

I had to alter some of the texts to make the formula work - but nothing
major.

Also see the attached zip-file:
http://www.excelforum.com/attachment.php?attachmentid=3630&stc=1

Hope it helped
Ola Sandström


+-------------------------------------------------------------------+
|Filename: Prob2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3630 |
+-------------------------------------------------------------------+

 

[aeiou]

OMG! How can i thank you?! The formula is a long one..."...lolz
Greatly appreciated!! I'll learn how to use Vlookup ^^;.....or rather
must learn it...haa