Question: Can anyone help me with the formula for step a? Please and thank you! On the Report worksheet: a) In cell E12 , add a

Can anyone help me with the formula for step "a"? Please and thank you!

On the Report worksheet:

a) In cell E12, add a VLOOKUP function nested in an IF function to retrieve the students uniform size. To prevent zeros from being displayed when the uniform size is not known, nest the VLOOKUP function in an IF function to leave the cell blank if no uniform size is entered. The value should be looking for an exact match. Copy the formula down to E38.

b) In cell F12, add an AND function nested in an IF function to determine whether the student has a permission slip and a uniform. If the student has a permission slip and the uniform size is not blank, then display Yes in the field; otherwise, display No. Copy the formula down to F38.

Can anyone help me with the formula for step "a"? Please and

REPORT worksheet:

thank you! On the Report worksheet: a) In cell E12, add a

M12 1 Students Teacher Competition? Uniform Size Permission Slip Student Since Level Price Per Hour Teacher Total Students Mark Debbie Total StudentID First Name Last NameInstrument Teacher Jenny Chuck Chuck Uniform Size Slip Student Since Skill level Price Per Hour 7/8/15 Advanced 2/18/18 Intermediate 11/4/15 Intermediate White Piano 9 000002Pandora Brock 10 000003 Inez Drums Clements Viola $25.00 12/29/15 7/13/14 Expert $40.00 $30.00 Minerva Burton Trumpet 7/9/17 Beginner 13 000006Summer SeeneyDrums 14 000007 Quyn 15 000008 Violet 16 000009 Clark 17 000010 Hyatt 18 000011 Plato 19 000012 s 20 000013 21 000014 Paki 22 000015 Baxter 23 000016 Pamela 24 000017 Tana 25 000018 Kennan 26 000019 Matthew Pickett 27 000020 Anastasia Marsh Cello 28 000021 Camille 29 000022 30 000023Meghan Serrano 31 000024 Erich Anne Chuck Trumbone Guitar Viola Drums Violin 6/9/16 Expert 11/7/15 Advanced 5/30/15 11/29/17 Advanced 11/27/14 Expert XS Ward Ward Waters $30.00 enny XXL 4/6/16 10/20/17 Beginner 3/28/16 Expert 3/12/17 Expert Ishmael Valenzuela Violin Oboe Guitar Trumbone enn Maddox Lambert Hardin enny Viola Piano Drums 4/4/16 Beginner 3/14/18 Intermediate 5/28/15 Expert 6/17/16 Beginner Chuck XXL XS $30.00 Jenny Chuck Chuck Anne 1/3/15 2/6/16 1/3/15 Intermediate 6/1/18 Beginner XXL Stanley Guitar Piano XXL $30.00 XXL 12/29/17 Advanced 1 Student Report Student ID 000018 Teacher Chuck Average Fee Skill Level Total Lessons Total Paid this Year Bonus Lessons Registration Type Travel Type Uniform Size Uniform Fee Registration Fee Transportation Fee Total 30.24 Bus XXL 45.49 500.00 80.00 625.49 235.00 1 earned 5 10 Competition Report 11 Student ID 12 000001 13 000002 14 000003 15 000006 16 000008 17 000010 18 000016 19 000018 20 000020 21 000022 22 000025 23 000028 24 000033 25 000044 26 000049 27 000053 28 000057 29 000059 30 000060 Student First Name Uniform Size Total Uniforms Ordered Student Last Name Permission Slip White No XXL Quantity needed Price per uniform45.49 Pandora nez Summer Violet Hyatt Pamela Kennan Anastasia Rina 18 Clements Ward Waters Lambert XXL Marshall Stanley Hayden Sanchez Solomon No Belle No Germaine Merrill Rinah Lisandra Mcmillan Hull Parks Lane XXL No

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!