> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bitscale.ai/llms.txt
> Use this file to discover all available pages before exploring further.
# Vlookup: Reuse Enriched Data
Last Updated At: Apr 2026
Try Bitscale Now!
## What Vlookup solves in Bitscale
When you build complex workflows, you often run into this problem:
* you enriched a lead or company in the past
* the same lead shows up again in a new grid or workbook
* you do not want to spend credits re-enriching it
If your CRM already stores those enriched fields, you can fetch from the CRM.
But if Bitscale is where your enriched data lives, you can reuse it with **Vlookup**.
Vlookup lets you search another grid for a matching record and pull specific columns back into your current grid.
It works similarly to Excel Vlookup.
## Where to find Vlookup
1. Open your grid
2. Go to **Enrichments**
3. Open **Data toolkit**
4. Select **Vlookup**
## How to set up a Vlookup
### Step 1: Choose the key column in your current grid
The key column is what you want to look up.
Example: key column = **Person name**
This means: for each value in `Person name`, check if that person exists in another grid.
### Step 2: Choose the grid to look up from
Select the destination grid where the data already exists.
Example:
* destination grid: a grid containing Bitscale team members
### Step 3: Map the matching column in the destination grid
Pick the column in the destination grid that should match your key.
Example:
* match `Person name` (current grid)
* with `Name` (destination grid)
### Step 4: Select the match condition
You can choose how matching works:
* **Exact** : only matches when the value is exactly the same
* **Contains** : matches when the destination value contains the key as a substring
Example use:
* use **Contains** if your key values are partial names
* use **Exact** if your key values are consistent and standardized
### Step 5: Choose which fields to fetch
Click **Fetch** to view all columns in the destination grid.
Select only what you want to pull back.
### Step 6: Save and run
Save the column, then run it:
* for a single cell (quick test)
* for multiple rows
* or for all rows
The matching record’s values will appear in the Vlookup result.
## Add returned fields as columns
After you run the lookup, you can open the result and use **Add as column** to create columns for the returned fields.
This is helpful when you want to run the lookup across a full list of names and store the pulled values directly in the grid.
## Common ways teams use Vlookup
### Avoid re-enrichment
If a lead was enriched in a previous grid, pull the result instead of rerunning the enrichment.
### Build exclusion lists
Maintain one grid of:
* people you should not contact
* companies you should not contact
Then in every outbound workflow:
1. run a Vlookup against the exclusion grid
2. if a match is found, skip processing that lead
### Create a CRM-like reference layer inside Bitscale
If Bitscale is where your clean data lives, Vlookup lets you treat old grids like a lightweight database you can reference anytime.
Try Bitscale Now!
## Need help?
If you want help setting up matching logic, exclusion workflows, or using Vlookup to reduce credit usage, reach out on the support channel.