ExcelLookup

 

Description

This is legacy functionality and should not be used moving forward.  Use the Lookup macro instead.

 

Performs a single value lookup against an Excel spreadsheet

 

Arguments

1.ExcelLookup - Name of the Macro.

2.Filename - The physical filename of excel spreadsheet or blank to indicate cached lookup.

3.Region - A named region or a worksheet name with $ added to the end. If blank a cached lookup will be used.

4.Value Column - The value to extract.

5.Search Column - Name of the column to search for the source value in.

6.Search Value - The value to search the Search Column for.

 

Examples

[ExcelLookup|C:\Lookup.XLS|Sheet1$|DatabaseCode|DepartmentCode|XXX]

Looks in the C:\Lookup.XLS file on the worksheet named Sheet one.  Searches column DepartmentCode for the value "XXX" and, when it locates the value, returns the contents of the DatabaseCode column for the matching row.

 

[ExcelLookup||CACHED|DatabaseCode|DepartmentCode|[Attribute|T3]]

Looks in the cached region CASHED.  Searches column DepartmentCode for the value of Attribute T3 and, when it locates the value, returns the contents of the DatabaseCode column for the matching row.

 

Notes

If multiple rows are found that meet the search criteria the first row is used. If the function contains a reference to a property or attribute that does not exist an error occurs. If the syntax is valid but no matches are found a blank value is returned.

 

This is legacy functionality and should not be used moving forward.  This functionality will be removed in a future version of pasTransfer.  Use the Lookup macro instead.

 

Copyright © 2024 pasUNITY, Inc.

 

Send comments on this topic.