What is Vlookup and Hlookup ?

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 first 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 first row of a table and return a value in the same column from a specified row.
Both functions are commonly used in Excel for data analysis and manipulation.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - This formula searches for the value in cell A2 in the range B2:D10 and returns the value in the 3rd column of the matching row.

Top Uber MIS Analyst interview questions & answers