What is v look up and h lookup

Question

Accepted Answer

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

VLOOKUP stands for vertical lookup and is used to search for a value in the leftmost column of a table and return a value in the same row from a specified column.
HLOOKUP stands for horizontal lookup and is used to search for a value in the top row of a table and return a value in the same column from a specified row.
Both functions are commonly used for data analysis, data manipulation, and creating reports in Excel.
VLOOKUP and HLOOKUP require a lookup value, a table range, a column or row index number, and an optional range lookup parameter.
Example: VLOOKUP(123, A1:B10, 2, FALSE) will search for the value 123 in the leftmost column of the range A1:B10 and return the corresponding value from the second column.

Top HCLTech Associate MIS Executive interview questions & answers