Returns a value from a table corresponding to a match found in the specified row.
DWHLookup([Value], [Table Name], [Lookup Row], [Result Row Index], [MatchType])
Where:
Value is the value to be found.
Table Name is the table within which the value is to be found.
Lookup Row is the number of the row containing the data to be searched for.
Result Row Index is the number of the row containing the data to be returned.
MatchType defines whether the match has to be exact (False) or the nearest found (True).
Rule | Meaning |
|---|---|
| DWHLookup(CarColourComboBoxReturn, Vehicles, 3, 2, FALSE) | The function looks in the Vehicles table for a match, in the third row of the table, to the value returned from the CarColourComboBox.
If a match is found, the function then looks up to the second row and returns the value in the same column 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 Color selected in the combo box is "Blue", so the function returns "Golf". |
Value | Table Name | Lookup Column | Result Column Index | MatchType | Outcome |
|---|---|---|---|---|---|
| "Blue" | Vehicles | 3 | 2 | False (Exact) | "Golf" |
| "White" | Vehicles | 3 | 1 | False (Exact) | "Renault" |
| 26 | People | 3 | 2 | True (Nearest) | "Dave Sharp" |
| 42 | People | 3 | 4 | False (Exact) | "Female" |
Vehicles Table
| Make | Volkswagen | Ford | Renault | Mazda |
|---|---|---|---|---|
| Model | Golf | Escort | Kangoo | 2 |
| Colour | Blue | Red | White | Black |
People Table
| Member ID | 42 | 44 | 96 | 107 | 251 |
|---|---|---|---|---|---|
| Name | Dave Sharp | Joe Bloggs | Sandra Shield | Thomas Knight | Isabelle Jones |
| Age | 25 | 37 | 42 | 21 | 56 |
| Gender | Male | Male | Female | Male | Female |