HLOOKUP

GPTKB entity

Statements (21)
Predicate Object
gptkbp:instanceOf Spreadsheet function
gptkbp:caseSensitive No
gptkbp:category Reference function
https://www.w3.org/2000/01/rdf-schema#label HLOOKUP
gptkbp:introducedIn Early versions of Excel
gptkbp:purpose Searches for a value in the top row of a table or array
gptkbp:range_lookup FALSE for exact match
TRUE for approximate match
gptkbp:relatedTo gptkb:XLOOKUP
gptkb:VLOOKUP
gptkbp:requires lookup_value
range_lookup
row_index_num
table_array
gptkbp:result Value in the same column from a row you specify
gptkbp:searchDirection Horizontal
gptkbp:type Lookup function
gptkbp:usedIn gptkb:Google_Sheets
gptkb:Microsoft_Excel
gptkbp:bfsParent gptkb:XLOOKUP
gptkbp:bfsLayer 7