VLOOKUP

GPTKB entity

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