Build a lookup cache for unique values in the specified column(s) The unique value can then be specified as a row parameter for the Item() method
A comma separated list of the unique valued column names or numbers
lst.SetupPKCache "CustomerID"
Debug.Print lst.Item("CompanyName", "BERGS")