a) In cell C3 enter a formula using the HLOOKUP function. b) Use structured reference to the amount column([Amount]) as the look up value. c) Look up that value in the table array shown in the range G2:J3 using an absolute reference to that range. d) Return the value in row2 of the table of array. e) Use TRUE as the range_lookup parameter, so that the formula will find the closest approximate value (as the level covers a range of membership amounts.)

F H Amount Level 250 1000 Sponsor Benefactor Patron B D E Wild Planet Conservation 1 Memberships Spring 2018 2 Member ID - Type - Animal Amount 3 CA-180 FaceLink Gorilla $1,000 4 CA-218 FaceLink Gorilla $1,500 5 OR-223 Million+ Gorilla $250 6 WA-219 Website Rhinoceros $1,250 7 OR-147 Website Lion $1,000 8 CA-150 FaceLink Rhinoceros $150 9 CA-217 Million+ Elephant $100 10 CA-240 Million+ Elephant $125 11 OR-132 Website Lion $50 12 WA-136 FaceLink Lion 13 WA-157 Million+ Cheetah $125 14 CA-141 FaceLink Cheetah $250 15 CA-167 Website Elephant $500 16 CA-173 FaceLink Cheetah $500 Local Offices California Oregon Washington Consolidated $75 S... +