O Search or enter web address Font Excel template - Saved le Home Insert Data Review View Help Tell me what you want to do Commen General - $. % Conditional Format - 2. -A.A 3 Formatting as Table endo Clipboard Alignment Number INDEX($B$2:$B$11, MATCH(MIN($C$2:$C$11),S$2:$C$11,0)) C D 1 Week Marketing Type Sales ($100s) Data Requested Data Formulas Used 1 FacebookAd 2 TVA 38 Week 4 Sales 61 INDEX($C$2:$C$11,4) 3 InstagramAd 4 BillboardAd 61 Week 3 Marketing Type InstagramAd -INDEX($A$2:$C$11.3.2) 6 5 Newspaper Ad 6 Google Ad 32 Row for SnapchatAd 8 =MATCH("SnapchatAd", $B$2. $B$11, 7 WebAd 55 9 8 SnapchatAd 55 Sales for SnapchatAd 5 5=INDEX(SCS2 SC$11, MATCH("Snap 10 9 TwitterAd 9 Twitter 44 11 10 RadioAd 50 Sales for any type 61 -INDEX(SCS2.SCS11, MATCH($F$13 Marketing Type Selection BillboardAd Click F13 for a dropdown box to selec Lowest Reported Sales GoogleAd -INDEX(SB52 SB511. MATCH(MIN(SA 65 Data Help Improve Office Q Search this course Ecel: Graded Tutorial #2 Question 1. Find the data requested in cell E3 by using the INDEX function in cell F3. Enter your answer in hundreds of dollars. $ hundred Question 2 Choose the correct data requested in cell E5 by using the INDEX function in cell F5. The Excel MATCH function searches for a value in a range of cells, and returns the relative position of that value in the range. Relative position means that the position begins with the location of the range, not the entire spreadsheet. The function is in the format of MATCH(lookup_value, lookup_array, [match_type]). Note that match_type is optional but the value of 0 will find an exact match. Using the same data as before, entering the function -MATCH("East", $A$1:$A$4,0) will return the value of "3." This function says 1) look at the range of $A$1:$A$4, 2) find the value "East" and then 3) return the relative position of that value. In this case "East" is the third value down the range. Back Next