The Discounts worksheet contains a two-dimensional table that has been set up to find the discount category of a ticket based on the weekday of travel and the fare category. In cell J3 of the Requests worksheet, use the INDEX function to retrieve the discount category for this ticket. Copy the formula down to cell J6. SHOW FORMULA IN CELL J3 OF CORPORATE REQUEST FORM.

D E F G H 1 Flight Discounts 2 3 4 5 6 A B Discount Category Fare Category Weekday 1 2 1 AA 2 Y Y 3 Y Y 4 Y Z 5 Z Y 6 X X 7 Y Y 3 X Y Z Z 7 8 AA 9 10 Z B D E I H K M N F G Corporate Request Form 1 Date Traveler Flight No. Corporate Fare Departure City Arrival City Base Fare Weekday Fare Category Discount Discounted Fare Airport Fee Jayhawks in Flight Total Ticket Price Less than Corporate Fare? u awn 8/1/2021 Frasier, John 8/2/2021 Simpson, Amanda 8/5/2021 Wxel, Thomas 8/6/2021 Wang, Robert 1013 $ 1079 $ 1068 $ 1002 $ 972.00 San Francisco 4,285.00 London 457.00 New York 837.00 New York Seattle Los Angeles Miami Seattle $ $ $ $ 272.00 2,277.00 665.00 939.00 1 2 5 6 1 3 2 3 6 D E F G H 1 Flight Discounts 2 3 4 5 6 A B Discount Category Fare Category Weekday 1 2 1 AA 2 Y Y 3 Y Y 4 Y Z 5 Z Y 6 X X 7 Y Y 3 X Y Z Z 7 8 AA 9 10 Z B D E I H K M N F G Corporate Request Form 1 Date Traveler Flight No. Corporate Fare Departure City Arrival City Base Fare Weekday Fare Category Discount Discounted Fare Airport Fee Jayhawks in Flight Total Ticket Price Less than Corporate Fare? u awn 8/1/2021 Frasier, John 8/2/2021 Simpson, Amanda 8/5/2021 Wxel, Thomas 8/6/2021 Wang, Robert 1013 $ 1079 $ 1068 $ 1002 $ 972.00 San Francisco 4,285.00 London 457.00 New York 837.00 New York Seattle Los Angeles Miami Seattle $ $ $ $ 272.00 2,277.00 665.00 939.00 1 2 5 6 1 3 2 3 6