1 Using only the functions INDEX & MATCH, write a formula in C18 to return the Sales 2 for the designated Region in C16 & Year in C17 3 4 2012 5 6 7 8 Regional Sales Report Region 2010 South 1,525,017 Northeast 2,704,237 North 3,563,687 West 4,489,700 Mid-Atlantic 2,167,319 Canada 1,861,239 Total 16,311,199 2011 1,504,678 2,135,564 4,441,886 2,651,064 1,357,850 3,578,280 15,669,322 1,227,847 1,411,782 4,805,431 796,330 776,850 4,069,389 13,087,629 2013 Total 1,019,616 5,277,158 716,535 6,968,118 3,716,674 16,527,678 2,898,601 10,835,695 3,024,542 7,326,561 1,475,301 10,984,209 12,851,269 57,919,419 9 10 11 12 13 14 15 16 17 18 19 20 Region: Year: Sales: North 2011 1