Share
Explore BrainMass

VLOOKUP function

Use the VLOOKUP function in the formula to determine gallons per hour based on the type of plane, then multiply the result by the number of flying hours to compute the amout of fuel for each flight. The table for VLOOKUP function extends over three columns.

Use the fuel required from part (a) to compute the additonal requirements for reserve fuel and holding fuel, which must then be added to the initial fuel requirements to get the total needed for a trip. Use the appropriate combination of relative and absolute references so that the formulas for the first flight can be copied to the remaining rows.

Attachments

Solution Summary

Use the VLOOKUP function in the formula to determine gallons per hour based on the type of plane, then multiply the result by the number of flying hours to compute the amout of fuel for each flight. The table for VLOOKUP function extends over three columns.

$2.19