---
schema_version: "1"
id: 53a2b634e41f184f673359810c36a305a0a9b07c97b51380ca76c0cb6784256b
title: Mapping Formulas
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_data_mapping_formulas.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_mapping_formulas.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 810b344ed098c8fff73b5c98333eab2ea4af680fc243a40a58b46cd5a1806a40
description: Use the mapping formula editor to apply formulas directly in your mapping fields. Using functions in your mapping formulas, such as text and date functions, allows you to perform more complex manipulations to your data.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Mapping Formulas

Use the mapping formula editor to apply formulas directly in your mapping fields. Using functions in your mapping formulas, such as text and date functions, allows you to perform more complex manipulations to your data.

For example, applying the COALESCE() function when there’s a change in your file column headers. (csv\[‘Media Buy Key’\]) —file name is uppercase, to (csv\[‘media buy key’\]) —file name is lowercase. CSV fields are case-sensitive, the new header doesn’t match the name specified in the mapping, causing the new file process to fail.

After applying this formula COALESCE(\[csv\['Media Buy Key'\], csv\['media buy key'\]\]), reprocess the data stream—changes are applied allowing any failed files to go through successfully.

The formulas are intuitive and use a similar syntax as Excel. More complex manipulations can be done with MVEL, a Java-based expression language.

- **[VLOOKUP](https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_mapping_formulas_vlookup.htm&release=264.0.0&type=5)**  
    Use the VLOOKUP function to retrieve specific data from a table. You can use it when you’re mapping fields from your source file to Marketing Cloud Intelligence Data Pipelines.
- **[FUZZYVLOOKUP](https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_mapping_formulas_fuzzy_vlookup.htm&release=264.0.0&type=5)**  
    The FUZZYVLOOKUP mapping formula helps identify two elements of text, strings, or entries that are similar but not identical.
- **[REPLACE](https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_mapping_formulas_replace.htm&release=264.0.0&type=5)**  
    Use the REPLACE function to replace characters or patterns in a string.