Execute Lookup

The Lookup function opens a selector panel, with values returned from a specified query. Selected values from the first column are then returned to the active cell in Excel, or, in a Parameters List. The Lookup function in Excel differs from a GEXS formula, as no formula resides in the spreadsheet. Queries (EDQs) available for processing from the Lookup function must reside in a specific location.

Setup

1. Ensure a folder labeled Explore exists in the root of the user's EDQ location.
2. In Query Designer, create the desired queries, and save them in the Explore folder.

Process

1. In Excel, select the desired cell, then, from the Spreadsheet Server Ribbon, select Lookup, or, from either the Spreadsheet Server Settings > Writeback Template or Select Oracle Public API panels, or the SWB Build a Template > Oracle Public API panel, select the desired cell in the Parameters List, and click Lookup. The system lists the available queries located in the Explore folder.


Note: Second level sub-folders are not listed.

2. Navigate to, and, select the desired query. The Select Item panel appears.

3. If necessary, reorder the columns, as the system returns value(s) from the first column.
4. In the Select Item panel, select the desired value(s) and, click Insert Selected Value(s). The selected values from the first column are returned to the active cell in the spreadsheet, or, in the Parameters List.