3. Registration fees, located in the EventDetails table, are based on a particular Event's EventID. Registration fees must be paid for each person attending the event. On the ClientRegistration worksheet, in cell I11 enter a VLOOKUP function to retrieve the registration fee from the EventDetails named range for the EventID in cell G11. Multiply the value retrieved by the number of guests in cell H11. Incorporate an IFERROR function to return a blank value if the VLOOKUP function returns an error. Format the value as Accounting and copy the formula down through I34.

File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Share Commer X Insert Calibri v 11 - A ' + V 2 Wrap Text Custom === Es DX Delete Paste BIU ;-;- : A $ -% - ) Merge & Center Sensitivity Conditional Format as Cell Formatting Table Styles Styles Formal Sort & Find & Filter Select Editing Analyze Data Analysis Clipboard Fant Alignment Number Cells Sensitivity Event Details EVNT-0037 B C D E F H 1 J K 1 Event Details 2 3 4 5 6 EventID EventName EventType Registration Fee EVNT-0037 2019 Benchmarking Conference Attendee Annual Conference $ 120.00 EVNT-0012 January HR Peer Networking Peer Networking $ 180.00 EVNT-0042 Toyota Plant Tour Plant Tour $ 250.00 EVNT-0022 Marsh Bellofram Plant Tour Plant Tour $ 190.00 EVNT-0017 Human Resource Professionals Peer Networking $ 110.00 EVNT-0032 State of the Industry Survey/Study $ 180,00 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ClientRegistration EventDetails EventAnalysis + + RY M Average 19-Jun-op Count 24 Sum: 25-Oct-02 File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Comments X Calibn 11 - A A ab Wrap Text General L 2PG 4 Insert DX Delete Format Paste BIU A + Merge & Center $ -% -3 Conditional Format as Formatting Table Styles Styles Sensitivity Surt & Find Filter Select Editing Analyze Data Clipboard Font Alignment Number Cells Analysis Sensitivity 111 X D E F H K Client Registrations 2 3 4 5 6 7 Board Member Discounts Discount EventType 5% Annual Conference 5 5% Peer Networking 7% Plant Tour 10% Survey/Study 9 9 Registration Fees Board Member Discount Event Discount Friends Discount 10 Guests Board Member Yes 12 1 2 1 1 2 15 Yes Yes Yes Contact Firstname CN-0001 Charity CN-0003 Justin CN-0004 Sydnee CN-0005 Blake CN-0006 Christine CN-0007 Cassidy CN-0008 Sloane CN-00010 Wing CN-00011 Avram CN-00012 Adena CN-00013 Barrett CN-00014 Angelica CN 00015 Christine CN-00016 Kevyn CN-00020 Heidi CN-00022 Rebecca CN-00023 Josephinc CN-00025 Fiona CN-00026 Jeremy CN 00027 Dora Lastname Calhoun Wallace Washington Bryan Tyson Lowe Shaffer Oneil Conrad Henry Gurizales Marquez Hughes Lara Estes Greene Henson Oneil Sullivan Delacruz Company Name SEA-LECT Plastics Corporation SMT LLC Southern Indiana Plastics Southwest Molding SPI Industries Inc Stcinwall Inc Stihl Incorporated Tasus Corporation - Alabama Tasus Corporation - Texas Team 1 Plastics Technical Industries Inc. Thogus Products Company Trademark Plastics Inc. Treemen Industries Inc Vantec Inc Venture Plastics Wabash Plastics Inc. GTM Plasties Inc. GTR Enterprises Hansen Plastics Corporation 17 18 19 20 21 22 23 24 25 26 27 Date Registered 11-Jan-191 17-Dec-18 16-Feb-18 09-Feb-19 07-Apr-19 30-Mar-181 23-Jul-191 17-Feb-18 05-May-18 22-Aug-18 01-Apr-18 01-Nov-18 14 Jun 19 10-Mar-18 21-Jul-18 28-Nov-19 24-May-181 01-Jul-18 04-Feb-18 22-Jun-18 EventID EVNT-0037 EVNT-0037 EVNT-0012 EVNT-2017 EVNT-00412 EVNT-0022 EVNT-0022 EVNT-0042 EVNT-0017 EVNT-0022 EVNT-0012 EVNT-0037 EVNT 0037 CVNT-0022 EVNT-0017 EVNT-0022 EVNT-0032 EVNT-2012 EVNT-0032 EVNT-0022 1 1 5 1 1 3 Yes 2 1 1 3 1 1 Yes Yes 1 3 2 1 29 30 71 32 33 34 ClientRegistration Event Details EventAnalysis +