How to use V look up and H look up

Question

Accepted Answer

VLOOKUP and HLOOKUP are Excel functions used to search for specific data in a table and return a corresponding value.

VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
HLOOKUP searches for a value in the first row of a table and returns a value in the same column from a specified row.
Both functions require a lookup value, table array, column index number, and range lookup (exact match or approximate match).
Example: VLOOKUP to find the price of a product based on its name in a table of products and prices.
Example: HLOOKUP to find the sales of a product based on the month in a table of products and monthly sales.

Popular interview questions of MIS and Back Office Executive