What is difference between vloockup and vloockup

Question

Accepted Answer

VLOOKUP and HLOOKUP are both Excel functions used to search for a value in a table, but VLOOKUP searches vertically while HLOOKUP searches horizontally.

VLOOKUP stands for vertical lookup and searches for a value in the first column of a table and returns a value in the same row from a specified column.
HLOOKUP stands for horizontal lookup and searches for a value in the first row of a table and returns a value in the same column from a specified row.
VLOOKUP is commonly used to look up data in a vertical format, while HLOOKUP is used for horizontal data lookup.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - This formula searches for the value in cell A2 in the first column of the range B2:D10 and returns the value in the third column of the range.
Example: =HLOOKUP(A2, B2:D10, 2, FALSE) - This formula searches for the value in cell A2 in the first row of the range B2:D10 and returns the value in the second row of the range.

What is difference between vloockup and vloockup

Popular interview questions of Data Analytics Consultant