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.
The HLOOKUP function make up: –
=HLOOKUP(value criteria, range, Exact match?)