Attendees who are also board members receive a discount off the registration fees. The discount amount varies based on the type of event. In cell J$11$ enter a formula that will return the discount amount if the registrant is a board member and return a blank value $("")$ if they are not.

Use a VLOOKUP function to retrieve the EventType from the EventDetails named range.

Use an INDEX function, with the cell range A$5$:B$8$ on the ClientRegistration worksheet as the array and the result of the VLOOKUP as the lookup$\_$value for the MATCH function needed for the row$\_$num argument.

Use an IF function so that the discount only applies to board members and all others will display as a blank $("")$

Format the result as Percentage with $0$ decimal places.

Copy the formula down through J$34.$