All Lookup functions are used to lookup information in a database. There are 2 kinds of lookup functions.
Apr 20 2014 01:59 PM
1) Vlookup Function
2) Hlookup Function
Vlookup Function - Looks up the data vertically down a particular column. we use this function when our comparison values are located in a column to the left data you want to find.
=VLOOKUP (Lookup_Value, Table_Array, Column_Index, Lookup_Type)
Hlookup Function - Looks up the data horizontally across a particular row. we use this function when comparison values are located in a row across the top of the table and you want to look down a specified number of rows.
=HLOOKUP (Lookup_Value, Table_Array, Row_Index, Lookup_Type)