DWVLOOKUP( [ Lookup], [ In], [ LookupColumn], [ ReturnColumn], [ MatchType] )
Searches a table for a specific value in a specified column and returns a value from the same row..
Lookup is the value to be found.
In is the table within which the Lookup value is to be found.
LookupColumn is the number of the column containing the data to be searched for.
ReturnColumn 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".|