Compare LOOKUP vs HLOOKUP

2 vs

Compare LOOKUP vs HLOOKUP side-by-side — differences, popularity and recommendation

Presets: VLOOKUP vs XLOOKUP SUM vs SUMIFS INDEX vs MATCH vs XLOOKUP IF vs IFS vs SWITCH COUNT vs COUNTA vs COUNTIF AVERAGE vs AVERAGEIF vs AVERAGEIFS MAX vs LARGE vs MIN TEXT vs TEXTJOIN vs CONCAT FILTER vs SORT vs UNIQUE ROUND vs ROUNDUP vs ROUNDDOWN

All functions Pick at least 2 functions

Feature

Lookup & Reference

=LOOKUP()

★ Winner

Syntax

Lookup & Reference

=HLOOKUP()

Syntax

Category

Lookup & Reference lookup-reference

Popularity

40 / 100

Views

◉ 9 views

◉ 8 views

Output

Mixed

Version

All versions

Volatile

Dynamic Array

Description

How to use the LOOKUP function in Excel to search in a single row or column and find a value from the same position in a second row or column.

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. 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."

Syntax

=LOOKUP(lookup_value, lookup_vector, [result_vector])

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Arguments

4 Arguments

lookup_value lookup_vector result_vector (Optional) array

4 Arguments

lookup_value table_array row_index_num range_lookup (Optional)

Examples

Tips

★ Recommendation — Winner: =LOOKUP()

=LOOKUP() is recommended based on higher popularity, newer version and Dynamic Array support.

Winner: =LOOKUP()