---
title: Vlookup
description: Combine two tables of data together based on a key
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# Vlookup

## Combine two tables of data together based on a key

***Function:***

Vlookup(table = *string*, lookup_col = *string*, lookup_table = *string*, match_on = *string*, return_cols = *list*)

 

***Parameters:***

*Table: *Table name on which to perform function

*Lookup Column*: Column to use to lookup values

*Table:* Table to join to the original table

*Match Column:* Column to match for the Vlookup

*Columns to Return:* Columns to return from the joined table

 

***Examples:***

Vlookup(table = Budget, lookup_col = "Geo", lookup_table = Expense Report, match_on = "Geography", return_cols = ["Actuals", "Plan", "Business Unit")