I am working on trying to figure out how to Nest two functions inside another function. I have multiple worksheets with data on them and I cannot for the life of me figure it out. I need to add a MATCH function nested in an INDEX function both nested in an IF function.
Students Instrument Teacher Competition? Uniform Size Permission Slip Student Since Level Price Per Hour
Piano Yes
Teacher Jenny Chuck Mark Anne Debbie Total
Total Students 2 5 2 1 0 1
StudentID First Name Last Name Instrument Teacher Competition? Uniform Size Permission Slip Student Since Skill level Price Per Hour
000001 Zia White Piano Jenny Yes XL No 7/8/2012 Advanced $30.00
000002 Pandora Brock Drums Chuck Yes M Yes 2/18/2015 Intermediate $25.00
000003 Inez Clements Viola Chuck Yes L Yes 11/4/2012 Intermediate $25.00
000004 Jael Boyer Bass Chuck No M Yes 12/29/2012
000005 Minerva Burton Trumpet Mark No L Yes 7/13/2014 Expert $40.00
000006 Summer Sweeney Drums Anne Yes XL Yes 7/9/2014 Beginner $30.00
000007 Quyn Ortiz Trumbone Chuck No XS Yes 6/9/2013 Expert $40.00
000008 Violet Ward Guitar Chuck Yes XL Yes 11/7/2012 Advanced $30.00
000009 Clark Ward Viola Mark XL 5/30/2012
000010 Hyatt Waters Drums Jenny Yes XL Yes 11/29/2014 Advanced $30.00
Student Schedule
Date StudentID Student Teacher Lesson Length Skill Level Total Fee
5/17/2015 000001 Zia Anne 2.00
11/5/2015 000001 Zia Jenny 0.50
7/28/2015 000002 Pandora Anne 1.00
8/1/2015 000002 Pandora Jenny 2.00
3/10/2015 000002 Pandora Mark 2.00
3/30/2015 000004 Jael Anne 0.50
10/10/2015 000006 Summer Anne 0.50
4/16/2015 000006 Summer Chuck 2.00
6/15/2015 000006 Summer Mark 1.00
7/30/2015 000006 Summer Mark 1.00
1/18/2015 000007 Quyn Jenny 1.50
10/5/2015 000008 Violet Chuck 1.50
9/24/2015 000009 Clark Chuck 2.00
1/16/2015 000010 Hyatt Chuck 1.50
5/21/2015 000010 Hyatt Mark 0.50
Bookmarks