Statements (30)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:software
|
| gptkbp:alternativeTo |
gptkb:XLOOKUP
INDEX MATCH |
| gptkbp:caseSensitive |
false
|
| gptkbp:category |
lookup function
|
| gptkbp:defaultRangeLookup |
TRUE
|
| gptkbp:documentation |
https://support.microsoft.com/en-us/office/vlookup-function-adceda66-30de-4f26-923b-7257939faa65
|
| gptkbp:errorIfNotFound |
nan
|
| gptkbp:hasSyntax |
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
|
| https://www.w3.org/2000/01/rdf-schema#label |
VLOOKUP
|
| gptkbp:introducedIn |
Excel 1.0
|
| gptkbp:limitation |
cannot look left
returns first match only slower on large datasets static column index |
| gptkbp:purpose |
search for a value in the first column of a range
|
| gptkbp:range_lookupFALSE |
exact match
|
| gptkbp:range_lookupTRUE |
approximate match
|
| gptkbp:relatedTo |
gptkb:HLOOKUP
LOOKUP |
| gptkbp:requires |
lookup_value
col_index_num range_lookup table_array |
| gptkbp:result |
value in the same row from a specified column
|
| gptkbp:usedIn |
gptkb:Google_Sheets
gptkb:Microsoft_Excel |
| gptkbp:bfsParent |
gptkb:XLOOKUP
|
| gptkbp:bfsLayer |
7
|