Schema della sezione

  • Using Excel functions to look up values
    • Excel supplies us with many functions to look up values in tables of data, for instance: VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, and others.

      A brief explanation on these functions, together with examples, can be found in the files which follow. You can also read the Excel help system.

    • Information about functions that look up values File
    • Some lookup examples File

    • Using the right Excel functions, try to reproduce the Excel worksheet that is represented in the pdf document which follows.

    • Were the Beatles good students? File