Lookup:
VLookup and HLookup are functions in Microsoft Excel.
VLookup:
V in VLookup stands for Vertical lookup.
Designed to work with data that is organised in to columns.
Syntax:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Range lookup:
Here range lookup is optional.
Either True or False.
True:
If an exact match is not found use the closest match.
False:
If an exact match is not found return error.
HLookup:
H in HLookup stands for Horizontal lookup.
Designed to work with data that is organised in to rows.
Syntax:
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example:
