if you have knowledge of excel tell me difference between hlookup,vlookup and xlookup?

Question

Accepted Answer

HLOOKUP searches for a value in the top row of a table, VLOOKUP searches for a value in the first column of a table, and XLOOKUP is a more versatile version of VLOOKUP and HLOOKUP.

HLOOKUP searches for a value in the top row of a table and returns a value in the same column from a specified row.
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
XLOOKUP is a more versatile version of VLOOKUP and HLOOKUP, allowing you to search for a value in any direction and return a corresponding value.
Example: HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Accepted Answer

HLOOKUP searches for a value in the top row of a table, VLOOKUP searches for a value in the first column of a table, and XLOOKUP is a more versatile version of VLOOKUP and HLOOKUP.
HLOOKUP searches for a value in the top row of a table and returns a value in the same column from a specified row.

VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

XLOOKUP is a more versatile version of VLOOKUP and HLOOKUP, allowing you to search for a value in any direction and return a corresponding value.

if you have knowledge of excel tell me difference between hlookup,vlookup and xlookup?

Top EXL Service Executive interview questions & answers

Popular interview questions of Executive

Top HR questions asked in EXL Service Executive