{"id":2377,"date":"2014-10-06T10:31:28","date_gmt":"2014-10-06T09:31:28","guid":{"rendered":"http:\/\/www.solidapps.co.uk\/blog\/?p=2377"},"modified":"2014-10-06T10:31:28","modified_gmt":"2014-10-06T09:31:28","slug":"driveworks-administrator-table-lookups-using-dwvlookup","status":"publish","type":"post","link":"https:\/\/www.solidapps.co.uk\/blog\/2014\/10\/driveworks-administrator-table-lookups-using-dwvlookup\/","title":{"rendered":"DriveWorks Administrator – Table Lookup’s Using DWVLookup"},"content":{"rendered":"

DWVLookup in DriveWorks Pro Administrator, returns a value from a table corresponding to a match found in the specified column.<\/p>\n

Syntax<\/h2>\n

DWVLOOKUP<\/strong>( [ Value], [<\/span>Table Name<\/span>], [<\/span>Lookup Column<\/span>], [<\/span>Result Column Index<\/span>], [<\/span><\/span>MatchType<\/span>] )<\/span><\/span><\/span><\/p>\n

[Value] is the value to be found.<\/p>\n

[Table Name] is the table within which the value is to be found.<\/p>\n

[Lookup Column] is the number of the column containing the data to be searched for.<\/p>\n

[Result Column Index] is the number of the column containing the data to be returned.<\/p>\n

[MatchType] defines whether the match has to be exact or the nearest found.<\/p>\n

 <\/p>\n

The video below shows an example of the DWVLookup function in action.<\/p>\n