---
schema_version: "1"
id: a7469094dd6a05dcf09ca9b4b48356b0e1dda1f6e07eec10e6a00c32785f4edc
title: FUZZYVLOOKUP
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_mapping_formulas_fuzzy_vlookup.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_mapping_formulas_fuzzy_vlookup.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7848b4411e4ecb106402be23021e0c065a92e089e7628bcb0a1b2b9608ec72e5
description: The FUZZYVLOOKUP mapping formula helps identify two elements of text, strings, or entries that are similar but not identical.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# FUZZYVLOOKUP

The FUZZYVLOOKUP mapping formula helps identify two elements of text, strings, or entries that are similar but not identical.

The formula takes the value provided as the first parameter and searches for it in the dimension provided as the second parameter. If the value is found, the formula returns the dimension value as a third parameter. Both the lookup dimension and the output dimension must be related to the same entity.

**Syntax:**

`FUZZYVLOOKUP(valueToSearch, searchDimension, returnDimension, threshold, workspaceLevel, {'streamfilter1', 'streamfilter2', ...}, useAutomaton)`

- To search through all the Workspace’s data, set `workspaceLevel` to true. To search only the current data stream, set it to false. The threshold parameter must be between 0 and 1, and 1 indicates an exact match.
- To narrow your search to specific streams, enter the data stream names inside curly brackets.
- If the search dimension contains more than 2,000 unique values, the formula fails.
- To increase the search of unique values up to 50,000, set the parameter to true. When set to false, only 2,000 values are searched.