DriveWorks Pro 15: VLookup [send feedback...]

VLOOKUP

Returns a value from a table corresponding to a match found in the first column.

Searches the first column in the selected table for a match (either exact or nearest; defined by MatchType) to the Lookup value. If a match is found, the data from the specified column in the matching row is returned.

Syntax

VLOOKUP( [ Value], [ TableName], [ ColumnIndex], [ MatchType] )

Value is the value to be found.

TableName is the table within which the Lookup value is to be found.

ColumnIndex is the number of the column containing the data to be returned.

MatchType defines whether the match has to be exact (False) or the nearest found (True).

Examples

Rule

Meaning
VLOOKUP(CarMakeComboBoxReturn, Vehicles, 2, FALSE)The function looks in the Vehicles table for a match, in the first column of the table, to the value returned from the CarMakeComboBox. If a match is found, the function then looks across to the second column and returns the value in the same row as the match found. The user has also specified that the match needs to be exact (denoted by the FALSE term). In this case, the Car Make selected in the combo box is "Volkswagen", so the function returns "Golf".

Example Outcomes

Value

TableName

ColumnIndex

MatchType

Outcome

"Volkswagen"Vehicles2False (Exact)"Golf"
"Mazda"Vehicles3False (Exact)"Black"
43People2True (Nearest)"Dave Sharp"
251People3False (Exact)56

Example Data

Vehicles Table

MakeModelColour
VolkswagenGolfBlue
FordEscortRed
RenaultKangooWhite
Mazda2Black

People Table

Member IDNameAgeGender
42Dave Sharp25Male
44Joe Bloggs37Male
96Sandra Shield42Female
107Thomas Knight21Male
251Isabelle Jones56Female

Table of Contents