VLOOKUP FUNCTION 8

• VLOOKUP FUNCTION


  tool for looking up a piece of information in a table or data set and extracting some corresponding data or information
• Lookup/Reference Function


  other term for VLOOKUP
• cell address


  specifies the value that we want to look up in the first column of a table
• table name


  data to be searched
• column number


  an integer specifying the number of the clumn of the supplied table array that you want to return a value
• =VLOOKUP(cell address, table name, column number)


  syntax for VLOOKUP function
• lookup value


  first argument?
• table array


  second argument?
• column index number


  third argument?