Statements (21)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:Spreadsheet_function
|
| gptkbp:caseSensitive |
No
|
| gptkbp:category |
Reference function
|
| 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
|
| https://www.w3.org/2000/01/rdf-schema#label |
HLOOKUP
|