Financial		Logical		Informational		Text
Mathematical		Statistical		Lookup		Reference		Formula Errors

VLookup is Vertical Lookup

Syntax
VLOOKUP( Lookup_value, table_array, Col_index_num, [range_lookup])

lookup_value	The value that is being searched
table_array	The data table containing lookup value and the corresponding column value
col_index_num	The Column number to fetch
[range_lookup]	Update as 0 - Mostly Zero unless required to fetch nearest values

VLookup cannot move to the left of a lookup value
You may use VLookup Wildcard characters like "?","*", etc.. Eg: Vlookup( "*"&"Data"&"?",array, col_index,0)

HLookup is Horizontal Lookup

Syntax
HLOOKUP( Lookup_value, table_array, row_index_num, [range_lookup])

lookup_value	The value that is being searched
table_array	The data table containing lookup value and the corresponding row value
row_index_num	The row number to fetch
[range_lookup]	Update as 0 - Mostly Zero unless required to fetch nearest values

HLookup cannot move to the Top of a lookup value

Lookup in the Vector form is used to lookup and value and provide its corresponding value from result vector

Syntax
LOOKUP(lookup_value, lookup_vector, result_vector)

lookup_value	The value that lookup vector searches for..
lookup_vector	Either One Row or One Column of Data Range
result_vector	Either One Row or One Column of Data Range with same size as lookup_vector

Lookup vector data has to be arranged in Ascending order for better results

The Lookup function returns the last matched value unlike VLookup and HLookup

Lookup in the Array form is used to lookup a value and provide its corresponding value

Syntax
LOOKUP(lookup_value, array)

lookup_value	The value that lookup array searches for..
array	Range of Cells

Lookup has better alternatives as Vlookup and Hlookup but is available for compatibility with other spreadsheet programs

Click Here to Download a copy of ExcelTechie Lookup Formulas Workbook