Question
Use a VLOOKUP function to retrieve the EventType from the EventDetails named range. Use an INDEX function, with the cell range A5:B8 on the ClientRegistration
Use a VLOOKUP function to retrieve the EventType from the EventDetails named range.
Use an INDEX function, with the cell range A5:B8 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 J34.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing Cases An Interactive Learning Approach
Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt
4th Edition
0132423502, 978-0132423502
