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
|