Question: L M 1 2 3 4 A B D E F G H J K In this worksheet you will use a combination of the

L M 1 2 3 4 A B D E F G H J K In this worksheet

L M 1 2 3 4 A B D E F G H J K In this worksheet you will use a combination of the Vlookup and Match. The problem with Vllookup is that you must always specify the Column number to use to find the value and sometimes you don't know what this Column value is. The Vlookup function should lookup Steamer in the whole table then the Match function should match the word Venti in the table of headings to find the Column number which in this case will be 5. This will then bring back the price of the coffee. You will use 6 7 Starbumps Coffee Menu 8 CLASSIC FAVORITES SHORT TALL GRANDE VENTI 9 Caffe Latte $2.15 $2.95 $3.75 $4.15 10 Cappuccino $2.25 $2.95 $3.65 $4.15 11 Caramel Macchiato $3.51 $3.75 $3.99 $4.25 12 Caffe Mocha $1.55 $3.25 $4.95 $4.40 13 White Chocolate Mocha $2.75 $3.45 $4.15 $4.55 14 Caffe Americano $1.60 $2.00 $2.40 $2.75 15 Cinnamon Dolce Latte $3.23 $3.99 $4.75 $5.15 16 Steamer $2.00 $2.25 $2.50 $2.75 17 Drip Coffee $1.55 $1.75 $1.95 $2.05 18 19 Question: Use Vlookup and Match to find the price of the coffee specified in cells A21 and B21? 20 21 Steamer Venti 22 23 24 25 26 27 28 29 30 31 32 33

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!