---
title: "What is vlookup function in excel?"  
description: "What is vlookup function in excel?"  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96524/what-is-vlookup-function-in-excel  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 1 minute  

---

# What is vlookup function in excel?

What is vlookup [function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function) in excel?

## Answers

### Answer by Hitesh Vohra

- **VLOOKUP** is an abbreviation for 'Vertical Lookup.' It's a function that tells [**Excel**](https://answers.mindstick.com/qa/96539/what-is-the-quick-way-to-return-to-a-particular-area-of-a-excel-worksheet) to look for a specific value in a column (the so-called'table array') in order to return a value from another column in the same row. The VLOOKUP function will be demonstrated in this article.
- A VLOOKUP function is made up of **four parts:**
- The value you're looking for;
- The value you're looking for and the range in which you're looking for it;
- The number of the column that carries the return value inside your selected range;
- For an exact match with the value you're looking for, **use 0 or FALSE**; For a close match, **use 1 or TRUE.**
- VLOOKUP is the syntax **([value], [range], [column number], [false or true])**

\

**Read More: [What is the use of a macro in excel?](https://answers.mindstick.com/qa/96528/what-is-the-use-of-a-macro-in-excel)**


---

Original Source: https://answers.mindstick.com/qa/96524/what-is-vlookup-function-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.