# LOOKUP function

• Learn how to use the LOOKUP function to create a Klip.
• Step-by-step instructions.

## How to use the LOOKUP function

The LOOKUP function is used to combine data, typically from two different data sources, specifically to use data from one data source as an index into another and then return a corresponding value.

Where

• Input:  an array of data to be used as indices into another data source (Keys).
• Keys: an array of data that intersects with Input data.
• Results:  an array of corresponding data from datasource2 (may be manipulated by a formula). Must contain the same number of items as Keys.

For each value in Input, search for a match in Keys and return the corresponding value from Results

NOTE: If multiple Keys match a value in Input, only the Result corresponding to the first matching Key will be returned.

## To use the LOOKUP function

The LOOKUP function is useful for correlating information from two data sources, as in the following example.

One data source has information on a sales rep and which client they are managing. The second data source has information on the manufacturer, the country, revenue and deals won. Our goal with the LOOKUP function is to be able to see the client, country, revenue and deals won for each sales rep. The following shows 3 different ways to use the LOOKUP function.

Lookup1 data source and Lookup2 data source.

### Method 1 - Look up and find text

1. Click  Select data or start formula and click Insert function.
2. Select Data Manipulation > LOOKUP.
3. Select the input element, then select values B:B from the Lookup1 data source.
4. Select the keys element, then select values A:A from the Lookup2 data source.

1. Select the results element.
2. Select values B:B from the Lookup2 data source.

### Method 2 - Look up and group values together

This method uses the GROUP and GROUPBY functions.

1. Click Select data or start formula and click Insert function.
2. Select Data Manipulation > LOOKUP from the function library.
3. Select the input element, then select B:B from the Lookup1 data source.
4. Select the keys element, the click Insert function and select Data Manipulation > GROUP from the function library.
5. Select A:A from the Lookup2 data source.

1. Select the results element and click Insert function.
2. Select Data Manipulation > GROUPBY from the function library.
3. Select A:A from the Lookup2 data source.
4. Select the measure element of the GROUPBY function, then select C:C from the Lookup2 data source.

### Method 3 - Lookup, group values together and use an IF statement to summarize values

This method uses the GROUP/GROUPBY, and IF functions.

1. Click Select data or start formula link and click Insert functionSelect Data Manipulation > LOOKUP.
2. Select the input element, then select B:B from the Lookup1 data source.
3. Select the keys element, then click Insert functionSelect Data Manipulation > GROUP.
4. Select A:A from the Lookup2 data source.
5. Select the results element and click Insert functionSelect Data Manipulation > GROUPBY.
6. Select A:A from the Lookup2 data source.
7. Select the measure element of the GROUPBY function and click the Insert functionSelect Logic > IF.

1. Click Insert expression in parenthesis and select D:D from the Lookup2 data source.
2. Select the ellipsis (...) beside the D:D element and select the = operator.
3. Select the ellipsis (...) beside the equals sign and click Insert literal string or number .
4. Type yes in the text field and click Apply.

1. Select the if true element and click Insert literal string or number and type 1 in the text field. Click Apply.
2. Select the if false element and click Insert literal string or number and type 0 in the text field. Click Apply.