FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Expert-Verified Answer. Explanation: VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches.

Detailed explanation-2: -Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for “Horizontal."

Detailed explanation-3: -HLOOKUP is an Excel function to lookup and which retrieves data from a specific row in a table. It searches for a value in the table’s first row and returns another value in the same column from a row according to the given condition.

Detailed explanation-4: -The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row.

Detailed explanation-5: -row-index-num is a row number in the same column of the table-array, a numeric value greater than or equal to 1 but less than the number of rows in the table-array. range-lookup-flag is an optional argument. It is a logical value: TRUE or FALSE. Enter FALSE to find an exact match.