FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -VLOOKUP allows you to search a data range that is set up vertically. HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns. LOOKUP and related functions are commonly used for business analytics in Excel as a way of slicing and dicing data for analysis.

Detailed explanation-2: -Look up vertically and horizontally Microsoft Excel used to have two functions for different lookup types, each having its own syntax and usage rules: VLOOKUP to look vertically in a column and HLOOKUP to look horizontally in a row. The XLOOKUP function can do both with the same syntax.

Detailed explanation-3: -Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

Detailed explanation-4: -If the range lookup argument is TRUE, or if a range lookup argument is not entered, VLOOKUP can find approximate matches. In this case, the lookup table must be sorted in ascending order by the first column in it; otherwise VLOOKUP may not return the correct value.