Bakson Drugs Data Entry and Computer Operator Interview Questions and Answers

HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a corresponding value from a specified row.

• HLOOKUP stands for Horizontal Lookup.

• It is commonly used to retrieve data from a table based on a specific criteria.

• The function requires four arguments: lookup_value, table_array, row_index_num, and range_lookup.

• The lookup_value is the value to search for in the top row of the table...read more

VLOOKUP is configured by specifying the lookup value, range of cells to search, column index number, and whether to perform an exact or approximate match.

• Specify the lookup value that you want to search for

• Specify the range of cells to search in

• Specify the column index number from which to return the value

• Choose whether to perform an exact match or approximate match

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search fo...read more