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

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.

Send comments on this topic.

Created with an evaluation copy of HelpSmith.
To remove this notice, you should purchase the full version of the product.