Using Lookup Function

VLOOKUP function is used for lookup tables in which the compare values are placed in the table's first column.

HOOKUP function is used when the compare values are placed in the table's first row.

Three pieces information needed to carry out the VLOOKUP funcion

• The entry you want it to look up
• The range of the lookup table
• The number of the column in the lookup table containing the value you want to look up