Write a formula with the VLOOKUP function for cell M11 (using the table in P10:R

Question

Write a formula with the VLOOKUP function for cell M11 (using the table in P10:R16) to compute the most expensive food item (Pancakes, Burger, etc.) that Fred can afford. Write it so that when the formula is copied to M12:M19 the food items for all remaining people are correct. Write a second formula for cell N11 (also using the table) to compute the price range (Cheap, Medium, etc.) for Fred. This formula will be copied to cells N12: N19, and also must do the right thing in each cell after the copy. Your answer for M11: =VLOOKUP (L11, $P$10:$R$16, 2) Your answer for N11: =VLOOKUP (L11, $P$10:$R$16, 3) 6 points each: 2 for cell, 3 for range (-1 for no $), 1 for column

Explanation / Answer

M11==VLOOKUP(L11,$P$10:$R$16,2)
M12==VLOOKUP(L12,$P$10:$R$16,2)
M13==VLOOKUP(L13,$P$10:$R$16,2)
M14==VLOOKUP(L14,$P$10:$R$16,2)
M15==VLOOKUP(L15,$P$10:$R$16,2)
M16==VLOOKUP(L16,$P$10:$R$16,2)
M17==VLOOKUP(L17,$P$10:$R$16,2)
M18==VLOOKUP(L18,$P$10:$R$16,2)
M19==VLOOKUP(L19,$P$10:$R$16,2)

N11==VLOOKUP(L11,$P$10:$R$16,3)
N12==VLOOKUP(L12,$P$10:$R$16,3)
N13==VLOOKUP(L13,$P$10:$R$16,3)
N14==VLOOKUP(L14,$P$10:$R$16,3)
N15==VLOOKUP(L15,$P$10:$R$16,3)
N16==VLOOKUP(L16,$P$10:$R$16,3)
N17==VLOOKUP(L17,$P$10:$R$16,3)
N18==VLOOKUP(L18,$P$10:$R$16,3)
N19==VLOOKUP(L19,$P$10:$R$16,3)

Name Budget Food Price Fred 17.00 Chicken Medium sam 8.00 Pancakes Cheap mary 23.00 Sushi Medium Carol 16.00 Chicken Medium joe 7.00 Pancakes Cheap bob 27.00 Prime Rib Expensive tom 9.00 Pancakes Cheap bill 3.00 Nothing Sorry! sue 15.00 Chicken Medium

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.