Vlookup_Hints (2).docx - The VLOOKUP Function requires...

This preview shows page 1 out of 1 page.

The VLOOKUP Function requires three pieces of data: =VLOOKUP( value to lookup, table array containing the data, column number from array to insert)Value to lookup: Both times you use VLOOKUP in the project, you should use the name of the membership type (Deluxe, Family, or Individual). Put the cell reference in the function containing that type. What cell on the “Andrews” row contains the membership type?Table array: There are nine cells in the table array containing membership type, cost and down payment– see the circled cells. The words “Membership, Cost and Down Payment” are not part of the table

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture