Searching for a value in first column of a table and returning value in the same row.

Syntax:

VLOOKUP(lookup value, table array:col_index, [approximate_match]).

Value refers to first column of a table.

Table array refers to two or more columns sorted in ascending order.

Column no in a table which represents matching value must be returned.

Approximate_match refers to find approximate column.

HLOOKUP:

Horizontal lookup.

Syntax:

HLOOKUP(table_value, table_array, row_index_no, range_lookup).

Value to be found as first row of a table.

Table array in which data is looked up.

Row index no in which the matching values are returned.

Range lookup to find an exact match.