Explain the Different Lookup Functions in Excel

Question

Examlex · Accepted Answer

The Answer is Excel provides some useful functions for finding specific data in a spreadsheet. These functions are useful in many applications:
VLOOKUPlookup_value, table_array, col_index_num) looks up a value in the leftmost
column of a table and returns a value in the same row from a column you specify. The table must be sorted in an ascending order.
HLOOKUPlookup_value, table_array, row_index_num) looks up a value in the top row of a table and returns a value in the same column from a row you specify. The table must be sorted in an ascending order from left to right.
INDEXarray, row_num, col_num) Returns a value or reference of the cell at the intersection of a particular row and column in a given range.
MATCHlookup_value, lookup_array, match_type) Returns the relative position of an item in an array that matches a specified value in a specified order.

Explain the Different Lookup Functions in Excel

Definitions: