---
schema_version: "1"
id: 1fc0370a954552308a32801d31633168e19f2b314daff34a83d51ae30a7b9459
title: range_lookup
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_range_lookup.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_range_lookup.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: be1926d690468e9773e3ce2881b7e4524028393ffc24227a30b0454f6de00411
description: Returns a value from within an upper and lower range of values in Salesforce Spiff, based on a range table. This function returns the specified column expression for that value.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# range\_lookup

Returns a value from within an upper and lower range of values in Salesforce Spiff, based on a range table. This function returns the specified column expression for that value.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

## Syntax

```
range_lookup(lookup_value, table, tiebreak_below, return_column)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| lookup\_value | Required | The value to look up in the range table. |
| table | Required | The range table to look up the value in. |
| tiebreak\_below | Optional | An expression that specifies how the function handles a lookup\_value that exists in multiple tiers. If you don't specify this argument, this function uses the tier with the lower value. |
| return\_column | Optional | The name of the range table's specific return column, enclosed in double quotes. This argument is required only if the range table includes multiple return columns, which is helpful when the same value ranges are used across multiple plans with different rates. |

## Considerations

You can use previously created summary calculations and mathematical operations in a range table. Reference these calculations with the syntax `WorksheetName!CalculationName`.

#### See Also

- [Considerations for Accelerator Functions in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_functions.htm&release=264.0.0&type=5 "Salesforce Spiff provides several functions that support accelerators, including mamount(), mpercent(), range_lookup(), and tier_payout.")