HLookup (Horizontal Lookup)

HLookup works on the same premise as VLookup but instead of looking up a value from a column and returning a value from a second column.

HLookup looks horizontally across the role and returns a value from another row as specified.

hlookup

The HLOOKUP function make up: –

=HLOOKUP(value criteria, range, Exact match?)