DriveWorks Pro 17: DWVLookup [send feedback...]


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


DWVLOOKUP( [Value], [Table Name], [Lookup Column], [Result Column Index], [MatchType] )

Value is the value to be found.

Table Name is the table within which the value is to be found.

Lookup Column is the number of the column containing the data to be searched for.

Result Column Index is the number of the column containing the data to be returned.

MatchType defines whether the match has to be exact or the nearest found.



DWVLOOKUP(CarColourComboBoxReturn, Vehicles, 3, 2, FALSE)The function looks in the Vehicles table for a match, in the third column of the table, to the value returned from the CarColourComboBox. 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 Colour selected in the combo box is "Blue", so the function returns "Golf".

Example Outcomes







"Blue"Vehicles32False (Exact)"Golf"
"White"Vehicles31False (Exact)"Renault"
26People32True (Nearest)"Dave Sharp"
42People34False (Exact)Female

Example Data

Vehicles Table


People Table

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

DriveWorks Tech Tips Portal

RGB Hex Conversion

This Tech Tip demonstrates how to convert RGB values into Hex values the ColorHex function.

View all Tech Tips

Table Functions


View all Tech Tips



To access the portal:

  1. Go to
  2. Login with your DriveWorks Pro account credentials, if asked
  3. Click the Visit Tech Tips Portal button for access


Table of Contents