# LOOKUP The LOOKUP function can look up values from an Infobridge query and load them inside an Inforiver visual. It can fetch measure values directly from Infobridge without creating an integration and importing measures/rows into your report.   ### Syntax ```javascript LOOKUP(queryIdentifier:string,measure:string,rows:[string],columns:[string]) //fetches data from the specified query and measure ``` ### Arguments queryIdentifier - It is used to identify the query from which data has to be fetched. String Argument (Required).

key- It specifies the key whose value is to be extracted. String Argument (Required). rows - Specify specific row dimension category values or use dimension names. Array Argument (Optional). columns- Specify specific column dimension category values or use dimension names. Array Argument (Optional). ### Examples **Example 1:** Refer to a specific row and column and fetch the measure value from Infobridge. The bridge contains the quarterly rebate rates for a set of products.

In the target visual, we can pull the rebate rate for the "Velo" product for Q4 using the LOOKUP function as shown.

LOOKUP function for specific row and column dimension categories

**Example 2:** Fetch values when the row and column dimensions are the same in the bridge and the target visual. The bridge contains the country-wise rebate rates for a set of products.

In the target visual, we can pull the rebate rate without specifying the rows and columns. They are automatically mapped within Inforiver.

LOOKUP function when the row and column dimensions match in the bridge and target visual

You can use the ROW/COLUMN identifiers when the row and column dimensions in the bridge are identical to the target visual.

**Example 3:** Fetch values when the row and column dimensions in the bridge and the target visual are not identical. The bridge contains a flat discount rate for product categories.

In the target visual, we can pull the discount rate although the bridge does not contain column dimensions and the row dimension hierarchy is different.

You can also fetch values from a bridge and map them to a visual column.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/formula-syntax/miscellaneous-functions/lookup.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.