Call Lookup to retrieve values for specified fields from a record that matches search criteria. KeyFields is a string containing a semicolon-delimited list of field names on which to search. 

KeyValues is a variant array containing the values to match in the key fields. To specify multiple search values, pass KeyValues as a variant array as an argument, or construct a variant array on the fly using the VarArrayOf routine. 

ResultFields is a string containing a semicolon-delimited list of field names whose values should be returned from the matching record. 

Lookup returns a variant array containing the values from the fields specified in ResultFields. 

If the search fields in KeyFields are indexed, Lookup uses the index. Otherwise Lookup creates a filter for the search.